OT: MySQL syntax help

[Kevin]

On 5/16/06 9:48 AM, "Darrin Chandler" <dwchandler at 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