thorak
-
Posts
1 -
Joined
-
Last visited
Never
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.
Selecting ID's not listed in Joined table
in MySQL Help
Posted
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