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:


      Key     FirstName

      1          Some

      2          Another



      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


      Key FirstName   LastName

      1     Some          One

      2     Another       One


      Any suggestions?



      Rune C