mysql - SQL 中 LEFT JOIN 之前的 AND 运算符

Question

我想检查用户的名字是否等于“bryan”，然后加入 tbl_usersinfo 和 tbl_profile。我的问题是它返回联接表中的所有行，而不是仅返回等于“bryan”的列的名字。

这是我的查询:

SELECT i.users_fname, i.users_lname, i.users_gender, i.users_campus,
i.users_email, i.course_code,
p.pic_location FROM tbl_usersinfo AS i 
LEFT JOIN tbl_profile AS p 
ON i.users_fname = 'bryan'
AND i.users_id = p.users_id

Answer 1

从join语句中取出i.users_fname = 'bryan'放在where语句中:

SELECT i.users_fname, i.users_lname, i.users_gender, i.users_campus, 
       i.users_email, i.course_code, p.pic_location 
FROM tbl_usersinfo AS i 
LEFT JOIN tbl_profile AS p ON i.users_id = p.users_id
WHERE i.users_fname = 'bryan'