mysql - 在mysql中连接表的正确方法是什么

Question

如何让这个 sqsl 查询工作:

SELECT student.LASTNAME,
       student.FIRSTNAME,
       student.IDNO,
       student.YEAR,
       parents.P_ADDRESS
FROM student
WHERE P_ADDRESS="Ambagat, Santol, LU"
RIGHT JOIN parents ON student.IDNO = parents.IDNO

我只想在连接上添加 where 语句。因为 w3schools 中的常见示例不包含 where 语句。请帮忙。

Answer 1

像这样

SELECT  student.LASTNAME, 
        student.FIRSTNAME, 
        student.IDNO, 
        student.YEAR, 
        parents.P_ADDRESS 
FROM    student RIGHT JOIN parents  ON  student.IDNO=parents.IDNO 
                                    AND P_ADDRESS="Ambagat, Santol, LU"