Access How can I join two columns from different table into one in MS Access?

Joined
Sep 13, 2010
Messages
1
Reaction score
0
Hi Guys, I have a questions. for example: i created 2 tables in MS Access as below:

Table 1
column A
1
2
3

Table 2
column B
4
5
6

How can I join 2 columns from different table to become 1 column in Table 3 ? like

Column C
1
2
3
4
5
6

Thanks in advance :)
 
Last edited:
Back
Top