Appending data where the column names are slightly different

P

Purnima Sharma

Hi,
I want to append data from various tables with different column headings
(e.g. tables having same column with different names such as loan #, Loan
Number, Loan No.) into a large table. Is there any way to append the data
programmatically using column position instead? Thanks.
Purnima
 
D

Douglas J. Steele

You can always use aliases in your query.

SELECT A AS Field1, B AS Field2 INTO Table1 FROM Table2
 
Top