WEB MySQL Question

Discussion in 'OT Technology' started by Jadix, Sep 28, 2007.

  1. Jadix

    Jadix The Nice Guy

    Joined:
    Jan 19, 2006
    Messages:
    7,877
    Likes Received:
    0
    I have two tables. One table is a list of students, and the other table is the list of students who have received an email. I want a query that will return a list of all the students who are in the student list, but not the email list. any tips?
     
  2. ///M Pilot

    ///M Pilot New Member

    Joined:
    Mar 16, 2006
    Messages:
    405
    Likes Received:
    0
    Location:
    Fort Liquordale, FL
    perform a JOIN .. right outer join should do what you want i believe

    or ..

    look up "select where NOT IN" syntax
     

Share This Page