[SOLVED] Tricky Query 2

[Link]

SELECT users.id, users.first_name, users.last_name, guides.mit_id
FROM guides, schedules_private AS sch 
LEFT JOIN users 
ON guides.user_id = users.id 
WHERE  sch.user_id = users.id 
AND (
   (sch.week = '2009-06-29' AND sch.day >= '3')
OR (
     sch.week > '2009-06-29' AND sch.week <= '2010-06-28' AND sch.day <= '3'
)
)

 

 

Why is this giving me u.id is an unknown column?

[MadTechie]

Well u.id isn't in that statement So MySQL shouldn't give any message about u.id

[Zane]

SELECT users.id, users.first_name, users.last_name, guides.mit_id
FROM guides, schedules_private AS sch 
LEFT JOIN users 
ON guides.user_id = users.id 
WHERE  sch.user_id = users.id 
AND (  ///    (sch.week = '2009-06-29' AND sch.day >= '3')
OR (
     sch.week > '2009-06-29' AND sch.week )
)

 

[fenway]

Solved how? This is a precedence issue.