Sorry for the tangent here, but I know there are some SQL guru's here and
I'm in a real bind (no pun intended!).

I have two tables in a MySQL database.

Table1
ID ~ Kernel
01 ~ 2.4.19
02 ~ 2.4.21
03 ~ 2.6.4
04 ~ 2.6.9
[snip]

Table2 
ID ~ hostname ~ kernel ~ arch
01 ~ web001AZ ~ 2.4.19 ~ x86
02 ~ web002AZ ~ 2.4.21 ~ x86
03 ~ web003AZ ~ 2.6.12 ~ sparc
[snip]

I need a query to pull every row from Table2 where the "kernel" field
matches ANY row in Table1.  Any ideas???

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