Columns in Full Outer Joins
 

This question applies to Excel 2002/Query 2002.

Although I can successfully create full outer joins with
Query 2002 and return the results to Excel 2002, I am
having trouble with formatting columns.

Example: Full outer join of two tables with a common
field, "CustomerID". What I want as a result is for
CustomerID from Table A and Table B to "merge" into a
single column with Table A taking precedence. Instead, I
get two columns, one containing CustomerID from Table A
and the other containing CustomerID from Table B.

Any way to get a result in which there is a single column,
CustomerID, that holds date from the table that has non-
null value for CustomerID?

Thanks in advance,
David