I have the following tables as a example.
EmpID, LastName, FirstName
I want to return all records from Table 1 that don't have an entry in Table 2 that don't have a Diploma for example so ReqID = 2
This query gives me all records back though not just Bob Jones' record. As they have other records that ReqID <> 2. Is there some way to group them to achieve this?
FROM Table1 LEFT JOIN Table2 ON Table1.EMPID = Table2.EMPID
WHERE Table2.ReqID <> 2;