>>>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....
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.