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