Adding to an existing table post a left join

[nickmarlborough]

Hi, 

I have a data set from TABLE 1 as the source which has the fields ID and NAME.  I have done a left join connecting on the field ID to bring in a new field [SCHOOL].

now i want to create a new field called KEY which is the combination of all 3 - ID, NAME and SCHOOL

how can i do that?

[Or]

Make another pass on the resident table.

Left Join(TABLE1)

Load ID, NAME, SCHOOL, ID & NAME & SCHOOL as Key

Resident TABLE1;

[nickmarlborough]

thanks for this - will try -

can i ask why do you put Left Join(TABLE1) - why cant it just be left join, i.e. what does the brackets of TABLE 1 do?

[Or]

Left Join without a table joins to the most recent table loaded. However, it is good practice to tell it which table you are joining on even when it's the most recent table, in case you end up moving sections of code around (and also because it's easier to read for the next person).