cross dependency?
Posted: Thu Jun 02, 2005 1:27 pm
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'what does this mean and how do i make it stop? im not even using a OUTER JOIN!?