> -----Original Message-----
> From: Ravindra Basavaraja [mailto:[EMAIL PROTECTED]]
> Sent: mercredi, 31. janvier 2001 14:50
>
> ...
> I want to display the records that are being repeated
> comparing with the id
> in table 1
> ...
>How do i write the query
select t1.id, t1.value
from table_1 t1
where 1 >= (select count (*) from table_2 t2
where t2.a_id = t1.id) ;
------
any ignorant comments made are the sole responsibility of J. R. Kilchoer and should not reflect adversely upon my employer.
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com
