How to write this sql sentence?

[Terry Ho]

Hi, all
I want to select field1 from table1, and plus field2 belongs with
table2, and the result will be store into table3. How to write this sql
sentence? Thank you very much!

 

[Van T. Dinh]

1. It sounds like you want to store redundant data??? If
the data is stored in Table1 and Table2, why do you need
to store the same data in Table3???

2. What is the relationship between Table1 and Table2?
Or you want Cartesian Join?

HTH
Van T. Dinh
MVP (Access)