>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.
If it's not broken, fix it until it is.
My Blog 
