Re: columns of one table are rows of another table

2006-02-01 Thread SGreen
JC <[EMAIL PROTECTED]> wrote on 02/01/2006 01:15:00 PM: > 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 of one table are rows of another table

2006-02-01 Thread JC
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