To join or not to join

[#1]

Good morning.  I have two tables in my load script...Sales History and Item Master.  I want to create a third table that takes the Item Number from Sales History and concatenates it with the Item Description from Item Master ultimatley resulting in a "Item Number Name" field.  Can someone please recommend the best way to do this?  All of this needs to be done in my load script.  I would like to do this using Resident loads.  Thanks.

[jagan]

Load the two tables Sales History and Item Master.  And then join the two tables and use Resident to form the key.

Regards,

jagan.

[#3]

Let's say I do the following:

Table1:

Load

ItemNumber

Resident SalesHistory;

LEFT JOIN (Table1)

Load:

ItemNumber,

ItemDescription

Resident ItemMaster;

Will this get the trick done?  If so where do I then add my new concatenated field?  Field would be ItemNumber & ' - ' & ItemDescription