OT: MySQL syntax help

Kevin plug-discuss at firstpacket.com
Tue May 16 09:43:40 MST 2006


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








More information about the PLUG-discuss mailing list