SQL Query to combine headers and values from two tables
Posted on 2007-04-03
I am trying to write an sql query via query analyzer in excel, or ms access that will combine the fields from one table as the header information and the values from another table as the row information.
For example....Talble1 has headeritem1, headeritem2, headeritem3,.......and table2 has value1, value2, value3...
I want to get a grid of values like
I am hoping someone can help me sort this out
Thanks for the help