5 Replies Latest reply on Aug 30, 2012 4:07 PM by mr_scott

    IS Valid with SQL

    kaostika

      I have 2 tables. I want to show a list of all records that DO NOT have related records. I want to use SQl to do this. I am not sure how in SQl to return NOT results.

       

      SELECT id

      FROM Table1

      INNER JOIN table2

      ON otherid

       

      I am guessing I will return all the ID that are Valid. I want the oppisite. Any ideas

       

      Oreste