Specifically select the field instead of using select *
>I have a SQL Select that gets data from 2 tables.
>
>There is a field called BoIdBase in both tables, so the result
>set includes BoIdBase_A and BoIdBase_B.
>
>I later then append this data into another table which also
>has a BoIdBase field.
>
>Problem is that the result set doesn't have BoIdBase, it has
>BoIdBase_A, so the third tables BoIdBase field is empty.
>
>Any way to stop this?
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown