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