Find a User not in another table for specified dates

[jbradley04]

Hello all,

 

I am trying to find a user that is NOT IN another table.  Here is the code I have but it is not working.  Any help would be greatly appreciated!

select * from user as u, 
where u.GroupID=9 and 
u.ID NOT IN (SELECT CBy FROM stories WHERE Con BETWEEN '2014-07' AND '2015-07' AND CBy IS NOT NULL)

Thanks for the help!

[Barand]

Joins are usually more efficient

SELECT *
FROM USER u
LEFT JOIN stories s
    ON u.ID = s.CBy AND s.con BETWEEN '2014-07' AND '2015-07'
WHERE s.CBy IS NULL

BTW, you shouldn't have had the comma at the end of your first line

Edited August 6, 2015 by Barand

[jbradley04]

Worked perfect!  Thanks.