Read the docs on "exists" that should be what you are looking for.

--rob

----- Original Message -----
From: "Diehl, Jeffrey" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Cc: "Diehl, Jeffrey" <[EMAIL PROTECTED]>
Sent: Tuesday, January 16, 2001 3:42 PM
Subject: Help with query. (*)


> I'm having difficulty writing a query which I really can't live without...
>
> I need to get a list of records from table A for which there are
> corresponding records in table B.  I've tried to use the intersect clause,
> but it doesn't seem to work, or it runs far too long.  For example:
>
> select * from A
> where 1=1
> intersect select * from A where
> B.x=A.x
> and A.y=B.y
> and A.z=B.z
> limit 100
>
> I need the most efficient method possible; my A tables have upward of 5
> Million records.  The B table, btw, only has about 100 records.
>
>
> Any help will be most appreciated.
>
>

Reply via email to