6 Replies Latest reply: Dec 15, 2010 6:59 PM by Rob Wunderlich RSS

    Regarding Concatenation!

      What will happen if I concatenate two tables like the way which is given below. What will be result and drawback if I do so. Will I be getting the same result like the way we load seperately. Please summarize!

      table1:

      SQL Select A,B,C,D,E from table1;

      Concatenate table2:

      SQL Select A,C,D,E from table2;

      Note: FYI Column B is not available in table2 whereas it is available in table1.