SQL newbie: How to extract all columns from multiple tables and save to a new table

• Ashish Dutt

  SSC Eights!

  Points: 952

  More actions

  November 16, 2014 at 8:06 pm

  #313255

  Dear friends,

  I have four tables.

  Table1 has four columns, Table2 has 3 columns, Table3 has eight columns and Table4 has 10 columns.

  Table3 and Table4 have a same column called Year. The datatype for the Year column is nvarchar(255). The data in the Year column in Table4 is coded as 2001-02, 2002-03 and so forth.

  All four tables have one common column called as schoolCode dataype is nvarchar(255)

  I want to extract all columns in all four tables based on the year and then save it into a new table. Please suggest how can I do this and if possible explain it too.

  Thank you for your help.

  Ashish

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  November 17, 2014 at 2:01 am

  #1758893

  Duplicate post.

  Replies here please: http://www.sqlservercentral.com/Forums/FindPost1635433.aspx

  -- Gianluca Sartori