Jump to content

Archived

This topic is now archived and is closed to further replies.

thorak

Selecting ID's not listed in Joined table

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

×

Important Information

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.