- List the teachers who have NULL for their department.
思路:这个题是简单查询
考点:测定空值用 IS NULL 而不是 = NULL
SELECT name
FROM teacher
WHERE dept IS NULL
- Note the INNER JOIN misses the teachers with no department and the departments with no teacher.
思路:INNER JOIN 就是求交集,会去掉含有空值行
SELECT t.name, de.name
FROM Teacher t INNER JOIN dept de
ON t.dept=de.id
3.Use a different JOIN so that all teachers are listed.
思路:用TEACHER表作为主表连接(想要哪个显示all 就用哪个作为主表)
考点:RIGHT JOIN & LEFT JOIN
SELECT t.name ,de.name
FROM teacher t LEFT