Post reply

Data load to table using 2 diff queries

  • 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

  • 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.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply