Data load to table using 2 diff queries

• swatianand83

  SSC Eights!

  Points: 930

  More actions

  May 20, 2009 at 10:56 pm

  #131208

  Hi,

  I have 2 different queries to be loaded to a common table. Between the 2 queries, we have a common column called 'Year'. On the basis of this year, we need to simple insert the data to a database table.

  Any suggestions how can we accomplish this?

  Thanks

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  May 20, 2009 at 11:00 pm

  #998074

  This is difficult to answer without seeing sample before-and-after data, but it sounds like a merge join might give you the results you need.

  ---