OT: MySQL syntax help

Kevin Brown kevin_brown at qwest.net
Tue May 16 17:22:34 MST 2006


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

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

Try to avoid the * if you don't really need to select all the data from 
all the fields of a table.  It might not seem like much, but it adds up 
as the tables grow larger.


More information about the PLUG-discuss mailing list