Kevin,
What was wrong with Mark's answer?
Thread #
938084 Message #
938124>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?
Steve Gibson