SQL Question

Are intersects and joins equivalent?

So is the query:

select part from orders_list1
intersect
select part from orders_list2

the same as

select a.part from orders_list1 a, orders_list2 b where b.part = a.part

Similarly is

select part from orders_list1
minus
select part_from orders_list2

the same as

select part from orders_list1 where part not in (select part from orders_list2)

If they are equivalent, when should one choose to use a set operator as opposed to a join or not in query?

Help appreciated

Paul Received on Wed May 26 1999 - 02:50:10 CDT