It wouldn't work - would add just another as _C.
Cetin

>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?