>Any way without having to specify the actual fields to get all the columns from table A, named as they exist, and then all the remaining fields from table B. I do not want to specify the fields that are common to both tables. I want matching records and only 1 occurance of all columns.
>
>For example:
>
>

>SELECT TableA.*, TableB.* WHERE A.Fieldx = B.Fieldx
>

>
>With the result being:
>
>

>Field1, Field2, Field3...
>

>
>Not:
>
>

>Field1_a, Field1_b, Field2, Field3...
>

Either explicitly name all fields or alter table afterwards. You don't have a 3rd choice.