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 = > "AKI00001" > > SELECT sum(consultation)+ sum(laboratory) FROM riftvalley,familymembers WHERE > familymembers.dependantid = riftvalley.memberid and familymembers.memberid = > "AKI00001" > > SELECT sum(consultation)+ sum(laboratory) FROM coast,familymembers WHERE > familymembers.dependantid = coast.memberid and familymembers.memberid = > "AKI00001" > > But i would like to run the querys above as one query that will return a > value that will be equivalent to the sum of the values of those queries. i > hope its possible. is it? i am using MySQL version 4.1.7
SELECT sum(consultation)+ sum(laboratory) FROM familymembers fm INNER JOIN coast ON fm.dependantid = coast.memberid INNER JOIN riftvalley ON fm.dependantid = riftvalley.memberid INNER JOIN nairobi ON fm.dependantid = nairobi.memberid WHERE fm.memberid = "AKI00001" Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]