>I have two tables with similar fields that I want to merge into one table. For example, my first table has fields: description, xvalue, yvalue. My second table has fields: description, xvalue, yvalue, codenum. I want one table with the fields description, xvalue, and yvalue. When I use the SELECT - SQL command, I get two fields for description, xvalue, and yvalue, because they are from different tables (i.e., descriptionA, desciptionB, xvalueA, xvalueB, etc.).
>
>Any suggestions? Thanks in advance!


explicitly name your columns.

select firstTable.*, secondTable.codenum from firstTable, secondTable where [join conditions here]