I'm running the following query:
SELECT S.Name As School,S.State,
CASE WHEN Unfinished.Cnt IS NULL THEN 'Yes' ELSE 'bNo/b' 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
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
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]