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
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
