Select

[cdg15]

Hi

A simple one I'm sure.

How do I select all records from one table that do not have a FK in another.

EG
Table_Class
ClassID
ClassName
TeacherID

Table_Teacher
TeacherID
Name

I want to see a list of Teachers who are not assigned to a Class.

Thanks in advance

 

[PHV]

SELECT T.TeacherID, T.Name
FROM Table_Teacher T LEFT JOIN Table_Class C ON T.TeacherID = C.TeacherID
WHERE C.ClassID Is Null

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[cdg15]

PHV, Great!

I was using = 0

Thank You