>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.
If you really need all the fields from Table1, then go for it. There is nothing wrong with Select Table1.*
If it's not broken, fix it until it is.
My Blog