Re: Combining several sum queries

2005-06-22 Thread leegold
On Wed, 22 Jun 2005 09:55:39 -0400, [EMAIL PROTECTED] said: > Jochem van Dieten <[EMAIL PROTECTED]> wrote on 06/22/2005 07:34:30 AM: > > > On 6/22/05, David Kagiri wrote: > > > When i run the queries below they all work just fine > > > > > > SELECT sum(consultation)+ sum(laboratory) FROM nairobi,

Re: Combining several sum queries

2005-06-22 Thread SGreen
Jochem van Dieten <[EMAIL PROTECTED]> wrote on 06/22/2005 07:34:30 AM: > On 6/22/05, David Kagiri wrote: > > When i run the queries below they all work just fine > > > > SELECT sum(consultation)+ sum(laboratory) FROM nairobi, > familymembers WHERE familymembers.dependantid = nairobi.memberid and >

Re: Combining several sum queries

2005-06-22 Thread Jochem van Dieten
On 6/22/05, David Kagiri wrote: > When i run the queries below they all work just fine > > SELECT sum(consultation)+ sum(laboratory) FROM nairobi,familymembers WHERE > familymembers.dependantid = nairobi.memberid and familymembers.memberid = > "AKI1" > > SELECT sum(consultation)+ sum(labora