Hi all,
I really need your help.
I have two tables:
table1:
id1|1|2|3|4|
000+a+b+c+d
001+e+f+g+h
.
.
.
and
table2:
id2|col1|col2|col3
1+val1+val2+val3
2+val4+val5+val6
3
4
.
.
.
columns (1,2,3,4,...) in table1 are rows (id2) in table2. I want to query
rows in table2 such that id2 IN (all columns in table1 except first
columns).
Is this possible to do in one statement? I know how to do this in
multiple queries, just wonder anyone knows how to optimize this.
Thanks,
JC
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]