Jump to content

thorak

New Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

thorak's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. 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
×
×
  • Create New...

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.