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
(text/plain)