>>>I heard from someone or somewhere that you should not use select table.* and, instead should list all the fields.
>>>
>>>I'm about to it with select table1.*, table2.field1, table2.field2... where I do need all the fields from table1, about 27 of them.
>>>Anyone have any input on this and if you should not do you have the reason?
>>>
>>>Thanks.
>>
>>See also Re: Create PRG from Cursors or Tables Thread #1239561 Message #1239635 if you need to put fields in the clipboard.
>
>Thought you all would find this amusing.
>After deciding that no harm could come from using select table1.*, table2.field1, table2.field2... and running the prg, the screen crashed. It seems that a field selected from table2 has the same name as one in table1. Back to listing all field names.
>
>Thanks again to all of you.

You always could use FieldNames:

select table1.*, table2.field1 AS Tbl2Fld1, table2.field2 AS Tbl2Fld2....