Very Computer

I have:

    Table1 t1
      Firstname,  [varchar]
      Lastname,  [varchar]
      Issueno, [int]
      col1,  [varchar]
      col2,   [varchar]
      col3   [varchar]......col400   [varchar]

    Table2 t2
      Indexno,   [varchar]  (The values in Indexno are: 'col1', 'col2',
'col3'.....and so on)
      Issueno  [int]

I want to write a query to join both tables and produce Firstname,
Lastname and issueno where col1 = '1' and compare the column name in
Table1 with the value of column Indexno in Table2.

How can I do this?

1) You have been here before; read the note at the bottom of this
posting.  There are no keys, and all columns are NULL-able and the way
you declared them, they will default ot VARCHAR(1), which is useless.
In fact, this thing is not a table!!  And there is no sample data.  

2) PLease, please, please read a book on database design.  I remember
your last post and you still don't know what a Normal Form is.  

--CELKO--
 ===========================
 Please post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, datatypes, etc. in your
schema are.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!