9 Replies Latest reply: Dec 30, 2011 1:57 PM by John Witherspoon RSS

    How can I compute a field in new table based on columns from two tables

      I have two tables:

      Table1:

      Key     FirstName

      1          Some

      2          Another

       

      Table2:

      Key     LastName

      1          One

      2          One

       

      And want to compute a third table:

      Table 3:

      Key FullName

      1     "Some One"

      2     "Another One"

       

      I've looked at a lot of Join and Load examples, but as far as I can see, none of them computes a field in a new table based on join of 2 other tables.

      The actual table1 contains millions of rows, so I would prefer not to create an intermediate table like this

      Temp:

      Key FirstName   LastName

      1     Some          One

      2     Another       One

       

      Any suggestions?

       

      Regards,

      Rune C