Select
the code which uses a JOIN correctly.

Question

Answer

SELECT  teacher.name, dept.name FROM teacher OUTER JOIN dept ON dept.id

Answer

SELECT  teacher.name, dept.name FROM teacher JOIN dept ON (dept = id)

Answer

SELECT teacher.name, dept.name FROM teacher
LEFT OUTER JOIN dept ON (teacher.dept = dept.id)

Answer

SELECT  teacher.name, dept.name FROM teacher, dept JOIN WHERE(teacher.dept = dept.id)

Answer

SELECT  teacher.name, dept.name FROM teacher, dept INNER JOIN ON (teacher.dept = dept.id)

Crowdly