query

[raji96]

How can i redo the below query without sub query.



Select tab1.first from
table1 tab1
where tab1.first not in
(select tab2.first from table2 tab2)

Basically i want to select a particular field from table one where the is no match in the table 2.

--thanks

 

[karluk]

I think the "minus" operator is just what you need:

select first from tab1
minus
select first from tab2;

 

[lewisp]

or.....

SELECT distinct tab1.first
FROM table1 tab1, table2 tab2
WHERE tab1.first = tab2.first(+)
AND tab2.first IS NULL