Link tables

[#1]

I have two tables I wish to link on a field that is common but not by name.

The first is a list of orders with a field marked roa-code (which is the Sales rep code). I then have a table with rep-code (which is the Sales rep code) and rep-desc.

Field roa-code and rep-code have the same data within them and I would like to be able to call the rep-desc so when reporting I get the rep-code and rep-desc together.

i.e.

TABLE 1     roa-code     sales-value  etc

TABLE 2     rep-code     rep-desc

output I want is

roa-code + rep-desc     sales-value

Thanks for any help

[Anonymous · Accepted solution]

alias the column name with same name for join .