Hi! I need to make a query that returns two fields from diferent tables, in a new table.
For example, I have the following two tables. Their fields have the same amount of records:
Table 1, Field 1
1
5
6
8
12
Table2, Field 1
4
8
9
10
15
Having that, I need to get the following query:
Query 1, Field 1
1
5
6
8
12
Query 1, Field 2
4
8
9
10
15
Can anybody help me with this, please?
Thanks.