sabret00the
12-13-2005, 07:58 PM
SELECT grps.groupid, grps.title, grps.description, grps.approved, grps.create_date, grps.leaderid, user.username AS leadername, grps_categories.catid, grps_categories.title AS catname, grps_setting.image_name, grps_setting.private_posts, grps_setting.moderate_members, grps_setting.hidden_group, grps_setting.edit_details
FROM grps_setting
LEFT JOIN user ON (user.userid = grps.leaderid)
LEFT JOIN grps ON (grps.groupid = grps_setting.groupid)
LEFT JOIN grps_categories ON (grps_categories.catid = grps.catid)
WHERE grps.groupid = 1;
MySQL Error : Cross dependency found in OUTER JOIN. Examine your ON conditions
Error Number : 1120
where's the cross dependency and why does this cause the query to malfunction?
FROM grps_setting
LEFT JOIN user ON (user.userid = grps.leaderid)
LEFT JOIN grps ON (grps.groupid = grps_setting.groupid)
LEFT JOIN grps_categories ON (grps_categories.catid = grps.catid)
WHERE grps.groupid = 1;
MySQL Error : Cross dependency found in OUTER JOIN. Examine your ON conditions
Error Number : 1120
where's the cross dependency and why does this cause the query to malfunction?