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_StringFROM pub_car.dbo.NVDTechnical INNER JOINpub_car .dbo.NVDDictionaryTechnical ON pub_car.dbo.NVDTechnical.TECH_TechCode = pub_car.dbo.NVDDictionaryTechnical.DT_TechCode WHERE (pub_car.dbo.NVDTechnical.TECH_Id = 30557)Which Gives : Tech_Id DT_Description Tech_Value_String 30557 Insurance Group 1 12 30557 Insurance Group 2 D 30557 Minimum Kerbweight 1220 30557 Length 4223 What I can't seem to acheive is:Tech_Id Insurance Group 1 Insurance Group 2 Minimum Kerbweight Length30557 12 D 1 220 4223 Any help appreciated as I am new to sql syntax. I don't even know if this is possible. I don't seem to be able to work out if any of the examples apply. Thanks again in advance.