kaostika

IS Valid with SQL

Discussion created by kaostika on Aug 27, 2012
Latest reply on Aug 30, 2012 by mr_scott

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

Outcomes