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

    IS Valid with SQL


      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