Help combining 3 tables

[luscioussarita]

Hi,

I have been trying to make an append query work for awhile and kinda gave
up. I want know how to combine three tables into one. Each table has a
primary key which can link all the tables as one. I am working with 150,000
rows of data. I would like to know what would be the best way to combine
these tables.

Is there a way to combine by column instead of by row?

Sarita

[Vika]

Hi Sarita,

If I understood you correctly, you want to create one table out of three tables. This can be done by creating Make -Table query. All you need to do is select desired fields from your three tables and run a query to create a new table.

Your query will look similar to this one:

SELECT tblTable1.FieldName1, tblTable1. FieldName2, tblTable1.FieldName3, tblTable2.FieldName1, tblTable2.FieldName2, tblTable2.FieldName3, tblTable3.FieldName1, tblTable3.FieldName2, tblTable3.FieldName3 INTO tblNewTableName




Hope this helps.


Regards,

Vika