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!?
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