[DB-SIG] Help on this query

[Titu Kim]

--- Andy Todd <andy47@halfcooked.com> wrote:
> Titu Kim wrote:
> > Hi there,
> >     I have two unrelated tables A and B which
> store
> > different data. Let say the followings are the
> table
> > schemas,
> > 
> > Table A
> > ID  number,
> > Date number,
> > EarnA  number
> > 
> > Table B
> > ID  number,
> > Date number,
> > EarnB number
> > 
> > ID in Table A and Table B is the same data. Assume
> > Date in Table A and Table B is in number format. I
> can
> > get EarnA from Table A with this query
> > 
> > Select sum(EarnA) from TableA 
> > where ID=XX and Date between mmm and nnn;
> > 
> > Similar for TableB i can get EarnB 
> > Select sum(EarnA) from TableB
> > where ID=XX and Date between mmm and nnn;
> > 
> > The number of rows in TableA and TableB are
> different
> > and EarnA and EarnB are two different data. Now if
> i
> > want to show EarnA and EarnB in one query for the
> same
> > ID in both Tables, how can i do this? Table
> schemeas
> > are simplified for discussion purposes.
> > 
> > Thanks.
> > 
> > 
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! - Official partner of 2002 FIFA World Cup
> > http://fifaworldcup.yahoo.com
> > 
> > 
> > _______________________________________________
> > DB-SIG maillist  -  DB-SIG@python.org
> > http://mail.python.org/mailman/listinfo/db-sig
> > 
> 
> Try the following SQL statement;
> 
> SELECT sum(A.EarnA), sum(B.EarnB)
> FROM   TableA A, TableB B
> WHERE  B.id = A.id
In this query, if they are m row of TableA n row in
TableB, each row in TableB will be added m times and
each row in TableA will be added n times. This is not
what i want.
Anyone have idea?
> This is bog standard SQL so I'd suggest you also
> take a look at a 
> tutorial 
>
(http://directory.google.com/Top/Computers/Programming/Languages/SQL/FAQs,_Help,_and_Tutorials/?tc=1)
> 
> 
> which may provide answers your questions more
> quickly than this mailing 
> list ;-)
> 
> Regards,
> Andy
> -- 
>
----------------------------------------------------------------------
>  From the desk of Andrew J Todd esq -
> http://www.halfcooked.com
> 
> 
> 
> _______________________________________________
> DB-SIG maillist  -  DB-SIG@python.org
> http://mail.python.org/mailman/listinfo/db-sig


__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com