Connecting a table to an expression through SQL

[kdbailey]

I created an expression field, titled "Trimmed Model", I want to connect this expression to table "Model to Color Shaft", field "Trimmed Model". I want the join to contain all data from the original expression.

What would the FROM statement look like??

[June7]

Can't you just use the Query Designer to build query that joins the two tables on common ID fields? Show sample data from these tables and the desired output.

[kdbailey]

This is a make query table, so I am avoiding connecting 2 query's.

[June7]

Don't understand. You want to make a new table just to avoid having to build query that joins queries? But then would have to join queries to accomplish the make table action anyway. Show sample source data and the desired results.