>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?
>

Use an expression to fill in the field. Suppose you need an extra 20 bytes length char field:

SELECT Field1, Field2, Field3, SPACE(20) AS Field4 FROM MyTable INTO TemporaryTable