mysql - 多个 INNER JOIN SQL ACCESS SYNTAX

Question

我正在尝试通过 INNER JOIN 和 table(users) 从 table(six_attendance, five_attendance) 获取数据。这是我尝试过的:

$query = mysql_query("SELECT * 
FROM
(users 
INNER JOIN six_attendance 
ON users.username = six_attendance.username)
INNER JOIN five_attendance 
ON users.username = five_attendance.username
WHERE six_attendance.username OR five_attendance.username ='$reg_no'");

Answer 1

$query = mysql_query("SELECT * 
FROM
users 
INNER JOIN six_attendance 
ON users.username = six_attendance.username
INNER JOIN five_attendance 
ON users.username = five_attendance.username
WHERE six_attendance.username='$reg_no' OR five_attendance.username ='$reg_no'");