Re: OT: MySQL syntax help

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