RE: sql query

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Wed, 31 Jan 2001 15:21:10 -0800
Message-Id: <10758.128000@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C08BDC.7ED1D280
Content-Type: text/plain;

charset="iso-8859-1"

> -----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

------_=_NextPart_001_01C08BDC.7ED1D280
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2652.35">

<TITLE>RE: sql query</TITLE>
</HEAD>
<BODY>

> -----Original Message----- > From: Ravindra Basavaraja [<A = HREF=3D"mailto:ravindra_at_sentica.com">mailto:ravindra_at_sentica.com</A>]</F=

ONT>
<BR><FONT SIZE=3D2>&gt; Sent: mercredi, 31. janvier 2001 14:50</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; ...</FONT>
<BR><FONT SIZE=3D2>&gt; I want to display the records that are being =

repeated

<BR><FONT SIZE=3D2>&gt; comparing with the id</FONT>
<BR><FONT SIZE=3D2>&gt; in table 1</FONT>
<BR><FONT SIZE=3D2>&gt; ...</FONT>
<BR><FONT SIZE=3D2>&gt;How do i write the query</FONT>
</P>

<P><FONT SIZE=3D2>select t1.id, t1.value</FONT>

from table_1 t1 where 1 >=3D (select count (*) from table_2 = t2
            = where t2.a_id =3D t1.id) ;

------
 any ignorant comments made are the sole = responsibility of J. R. Kilchoer and should not reflect adversely upon = my employer.

<P><FONT SIZE=3D2>&nbsp;</FONT>
<BR><FONT SIZE=3D2>Jacques R. Kilchoer</FONT>
<BR><FONT SIZE=3D2>(949) 754-8816</FONT>
<BR><FONT SIZE=3D2>Quest Software, Inc.</FONT>
<BR><FONT SIZE=3D2>8001 Irvine Center Drive</FONT>
<BR><FONT SIZE=3D2>Irvine, California 92618</FONT>
<BR><FONT SIZE=3D2>U.S.A.</FONT>
<BR><FONT SIZE=3D2><A HREF=3D"http://www.quest.com" =

TARGET=3D"_blank">http://www.quest.com</A> Received on Wed Jan 31 2001 - 17:21:10 CST