Re: Need Help with SQL

hi,
i hope this query may solve your requirement.

select acctno from table1 group by ssn having count(*) > 1 union
select acctno from table1 where no in (select acctno from table2) union
select acctno from table2 group by ssn having count(*) > 1 union
select acctno from table2 where no in (select acctno from table1);

thanks,
senthil

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jul 03 2000 - 00:00:00 CDT