thorak Posted August 7, 2003 Share Posted August 7, 2003 ok... so here is what i have... and its driving me crazy. I have 2 tables.... tblmessage and tblwhoview. tblmessage = all the message tblwhoview = who is allowed to view the messages I need to write a query that will select all the message from tblmessage that are not in the tblwhoview.... so i tried these, but nothing is working. SELECT DISTINCT M.ID FROM tblmessages M, tblwhoview W WHERE M.ID != W.MID SELECT DISTINCT M.ID FROM tblmessages M LEFT JOIN tblwhoview W ON M.ID=W.MID WHERE M.ID != W.MID can someone please help me.... im going crazy. thanks ryan Quote Link to comment https://forums.phpfreaks.com/topic/848-selecting-ids-not-listed-in-joined-table/ Share on other sites More sharing options...
Barand Posted August 8, 2003 Share Posted August 8, 2003 You were getting close with that second attempt. SELECT DISTINCT M.ID FROM tblmessages M LEFT JOIN tblwhoview W ON M.ID=W.MID WHERE W.ID IS NULL Quote Link to comment https://forums.phpfreaks.com/topic/848-selecting-ids-not-listed-in-joined-table/#findComment-2846 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.