6 Replies Latest reply: Oct 14, 2012 5:15 AM by Lav Jain RSS

    concatenating 4 tables into one and then inner join the resulted table with another one

      Hi there,


      I have 4 tables with the same columns that are updated every day.

      Think of them as transaction data from 4 different bussinesses.

      I used concatenate to load all of these tables into one General transactions table.


      I now want to inner join this General transactions table with another table that contains customer data.

      Unfortunately i want to keep only the COMMON customer data between these two tables.


      Should i use inner join or something else?


      Thanks in advance guys.