RE: sql query

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Wed, 31 Jan 2001 20:34:25 -0800
Message-ID: <F001.002A6A41.20010131152020@fatcity.com>

> -----Original Message-----
> From: Ravindra Basavaraja [mailto:ravindra_at_sentica.com]
> 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 Received on Wed Jan 31 2001 - 22:34:25 CST