Hi All,

I want to select a few fields from a table into a temporary table along with
a field that is not in the first table.

e.g

SELECT MyTable Field1, Field2, Field3 FROM MyTable + OtherField
INTO TemporaryTable

Can this be done?

Thanking you in advance,

Ger.