Select statement with Field Names listed in another table
Posted on 2006-05-31
I have a table that lists a bunch of field names from multiple tables. I have the names setup with the table.fieldname so that I can draw information Example:
I also have the from statement built that has all the joins necessary to grab the data from these field names.
This sql statement/stored procedure will also have where and order by statements that will need to be appended to the end of the procedure.
I need to know the best way to do this.
An good and clear example would be great and would be worth 500 pts. to me