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