On 5/16/06 9:48 AM, "Darrin Chandler" <dwchandler@stilyagin.com> wrote:

> On Tue, May 16, 2006 at 09:43:40AM -0700, Kevin wrote:
>> I need a query to pull every row from Table2 where the "kernel" field
>> matches ANY row in Table1.  Any ideas???
> 
> See docs for EXISTS

PERFECT!  Thanks Darrin!  Something like this will work.

SELECT *
FROM Table2
WHERE EXISTS
  (select *
    from Table1
    where kernel = Kernel);

...Kevin


---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change  you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss