Combining several sum queries

2005-06-22 Thread David Kagiri
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(laboratory) FROM riftvalley,familymembers WHERE

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(laboratory)

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 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,