Yes, it's possible.

SELECT MyTable Field1, Field2, Field3, ;
  SPACE(20) AS Charfield4, 00000000.00 AS Numfield5, {} as Datefiled6, ...; 
       FROM MyTable;
       INTO TABLE TemporaryTable

Or, if you want more control over additional fields type and size, create a cursor with additional fields and add it to the query. It's the only way to add integer, money or memo type fields to the query.

Create Cursor crsFields ( ;
  Charfield4 C(2), Numfield5 N(10,2), Datefiled6 D, Intfield7 I, Memofield8 M)
SELECT MyTable Field1, Field2, Field3, crsFields.* ;
       FROM MyTable, crsFields ;
       INTO TABLE TemporaryTable

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