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.