I'm running the following query:
SELECT S.Name As School,S.State,
CASE WHEN Unfinished.Cnt IS NULL THEN 'Yes' ELSE 'No' END As
AllSubmitted,
COALESCE(Part.Cnt,0) As StudentCount,
COALESCE(Adv.Cnt,0) As AdvisorCount
FROM InvHead I
JOIN Schools S On S.ID=I.ChapterID
LEFT OUTER JOIN (SEL
Hi,
I saw the error.
For interested it is in the place.latitude BETWEEN section
Anthony
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I think this is an error, anyways i'm trying to join 6 tables together.
and when i do EXPLAIN SELECT i get the message in comments
""Impossible WHERE noticed after reading const tables""
this is my statment basically
SELECT table1.id
FROM table1,table2,table3,table4,table5,place
WHERE
table1.
