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 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 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
Archived
This topic is now archived and is closed to further replies.