[SOLVED] Selecting results from 1 table that don't exist in another

[Buchead]

Hi all,

 

I have 2 tables (staff and training), with the link between them being staffID. What I'm trying to do is pull out a list from staff which don't have any entries in training. I thought I'd have to use COUNT but can't seem to get it working.

 

I assumed the query should mainly be:

 

SELECT s.* FROM `staff` AS s LEFT JOIN `training` AS t ON s.staffID=t.staffID HAVING (COUNT(XX) = 0)

 

but can't get anything working where XX is. I've tried running an inner queries comparing the 2 tables and pulling data from just 1 table. If I put in 't.staffID' where XX is it returns only the 1st entry from `staff`, despite `training` being completely empty.

 

Also tried putting the closing bracket of the count before the '= 0' bit, and removing the brackets. Same results.

 

There's clearly a glaring mistake somewhere but I can't see it. Please can anyone help?

 

Thanks.

[fenway]

You don't need HAVING ... you need WHERE t.staffID IS NULL.

[Buchead]

Thanks. Simply assumed I needed to do a count......