jbradley04
-
Posts
58 -
Joined
-
Last visited
jbradley04's Achievements
Member (2/5)
0
Reputation
-
Find a User not in another table for specified dates
jbradley04 replied to jbradley04's topic in MySQL Help
Worked perfect! Thanks. -
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!