Posted by: mvc January 15, 2014
Login in to Rate this Post:
0
?
This really depends on the Relation between two tables. This could be the syntax for two tables containing same column say student_Id.
select *
from table one
where tableone.student_Id NOT IN
( Select tabletwo.student_ID
from table two) ;
select *
from table one
where tableone.student_Id NOT IN
( Select tabletwo.student_ID
from table two) ;