select table1.field1 from table1 where table1.field1 not in1st Rank using outer join:
(select table2.field1 from table2);
SELECT table1.field12nd Rank using not exists:
FROM table1, table2
WHERE table1.field1 = table2.field1(+) and
table1.field1 is null;
SELECT table1.field1
FROM table1
WHERE NOT EXISTS (SELECT table2.field1 FROM table2 WHERE table1.field1 = table2.field1)
0 comments:
Post a Comment