I have a database with over twenty tables and need to transpose only two columns from different tables to display as rows. The tables are linked by a fields in each table. At the moment I have: SELECT TECH_Id , DT_Description , TECH_Value_String FROM pub_car . dbo . NVDTechnical INNER JOIN pub_car ....