Linking an expression with a second Table

[Andrew Pla]

When running a query i have created an expression which is simply 2 fields joined together. JOBLOC:[JOB]&[LOCATION]. I want to link this expression with a field in a second table [SCOPE], but for the life of me can't remember how i did it. Either in query design or SQL.

Thanks for your help!

 

[Sergeant]

Make another query, use this query and the other table as tables in the new query...link away!