cross dependency?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
shiznatix
DevNet Master
Posts: 2745
Joined: Tue Dec 28, 2004 5:57 pm
Location: Tallinn, Estonia
Contact:

cross dependency?

Post by shiznatix »

Code: Select all

SELECT
  user_id,
	person.first_name AS person_first_name
FROM
  mdl_usr_users AS base
LEFT JOIN
  mdl_cv_personal_info AS person
ON
  person.fk_user_id = base.user_id
LEFT JOIN
  mdl_cv_skills_languages AS lang
ON
  lang.fk_skills_id = sid.skills_id
LEFT JOIN
  mdl_cv_skills AS sid
ON
  sid.fk_user_id = base.user_id
WHERE
  person.first_name = 'John'
OR
  lang.fk_dd_language_id = '2'
this query is giving me "Cross dependency found in OUTER JOIN. Examine your ON conditions"

what does this mean and how do i make it stop? im not even using a OUTER JOIN!?
User avatar
shiznatix
DevNet Master
Posts: 2745
Joined: Tue Dec 28, 2004 5:57 pm
Location: Tallinn, Estonia
Contact:

Post by shiznatix »

never mind, the problem was in the order of the left joins, aparently its a bug of some sort, many people were complaining that there is no documentation on the website about it and that nothing has been done about it. dunno but i got it to work so im not mad
Post Reply