Kevin,

You may need to either do a UNION -or- SELECT one record or the other depending on certain criteria.

Are the two tables related by the BoldBase field? If so, perhaps you should be SELECTing that field from only one of the tables.

Without seeing the structures, relationships and the actual query, it is difficult to give a more definitive answer.

Dana

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