Hi
I our database there is one table that will grow into tetrabytes within a short
time.
I would like to know how i can reduce full table scans.
I have used separate tables as per region for now but the problem is if i
create a new table i am forced to recompile the application.
I can easil
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
f
i get an error when i run the query below though SQLyog.
SELECT memberid,fullname FROM members WHERE memberid =
(select distinct memberid FROM familymembers)
the error is
Error Code : 1064
You have an error in your SQL syntax. Check the manual that corresponds to your
MyS
