I hope the question is OK :) The first 4 queries work fine, the last causes the error. I'm probably missing something obvious, but this is complex for me.
TIA for any tips, verdon GODD ======== SELECT volunteers.volunteer_id,volunteers.first,volunteers.middle,volunteers.last,v olunteers.organization FROM volunteers WHERE volunteers.volunteer_id > 0 ORDER BY volunteer_id SELECT volunteers.volunteer_id,volunteers.first,volunteers.middle,volunteers.last,v olunteers.organization FROM volunteers RIGHT JOIN availability ON volunteers.volunteer_id = availability.volunteer_id WHERE volunteers.volunteer_id > 0 AND availability.start_time <= 0 AND availability.end_time >= 0 AND availability.day_of_week = 1 ORDER BY volunteer_id SELECT volunteers.volunteer_id,volunteers.first,volunteers.middle,volunteers.last,v olunteers.organization FROM volunteer_skills RIGHT JOIN volunteers ON volunteer_skills.volunteer_id = volunteers.volunteer_id RIGHT JOIN phone_numbers ON volunteers.volunteer_id = phone_numbers.volunteer_id WHERE volunteers.volunteer_id > 0 AND ( string_id = 6 and skill_level >= 3) AND phone_numbers.number LIKE '%345%' GROUP BY volunteer_skills.volunteer_id ORDER BY volunteer_id SELECT volunteers.volunteer_id,volunteers.first,volunteers.middle,volunteers.last,v olunteers.organization FROM volunteer_skills RIGHT JOIN volunteers ON volunteer_skills.volunteer_id = volunteers.volunteer_id RIGHT JOIN availability ON volunteers.volunteer_id = availability.volunteer_id WHERE volunteers.volunteer_id > 0 AND ( string_id = 6 and skill_level >= 2) AND availability.start_time <= 0 AND availability.end_time >= 0 AND availability.day_of_week = 1 GROUP BY volunteer_skills.volunteer_id ORDER BY volunteer_id ================ NO GOOD ================ SELECT volunteers.volunteer_id,volunteers.first,volunteers.middle,volunteers.last,v olunteers.organization FROM volunteers RIGHT JOIN phone_numbers ON volunteers.volunteer_id = phone_numbers.volunteer_id RIGHT JOIN availability ON volunteers.volunteer_id = availability.volunteer_id WHERE volunteers.volunteer_id > 0 AND phone_numbers.number LIKE '%345%' AND availability.start_time <= 0 AND availability.end_time >= 0 AND availability.day_of_week = 1 ORDER BY volunteer_id SQL Error: Cross dependency found in OUTER JOIN. Examine your ON conditions -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
