>>> 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.
---------------------------------------------------
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