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