Rate Post

Rate this post by selecting a number. 1 is the worst and 5 is the best.

Author

Message

Symbol_of_king
Kurra Bewarse
Username: Symbol_of_king

Post Number: 2119
Registered: 12-2005
Posted From: 72.209.237.32

Rating: N/A
Votes: 0

Posted on Wednesday, July 10, 2013 - 11:15 pm:

with T1 as
(
select vendor_name, address_line1, vendor_id
from table a, b
where
..
Union
select vendor_name, address_line1, vendor_id
from table x, y
where
..
)

select vendor_name,address_line1,T1.vendor_id
from T1,
(select count(*) cnt,vendor_id from T1 where address_line1 is not null group by vendor_id) T2
where T1.vendor_id=T2.vendor_id(+) and

(T1.address_line1 is not null or (T2.cnt=0 and T1.address_line1 is null));

--I dont know if it is right or wrong... just tried to answer it :-)

Administration