On the question of adding two tables

xiaozhuyaya1

Is there any way to combine two tables (possibly with different fields) into one table:
Table A
Field 1 field 2 field 3
1 aa1 bb1
2 aa2 bb2
4 aa4 bb4

Table B
Field 1 field 2 field 4
3 aa3 cc3
5 aa5 cc5
6 aa6 cc6

Synthesized table:
Field 1 Field 2 Field 3 Field 4
1 aa1 bb1
2 aa2 bb2
3 aa3 cc3
4 aa4 bb4
5 aa5 cc5
6 aa6 cc6

The value of field 1 in both tables cannot be duplicated

michealhenry

The value of field 1 in both tables cannot be duplicated

This means that the data of field 1 of table a cannot be the same as the data of field 1 of table b?

If so:

select field 1, field 2, field 3, '' as field 4 from table A
UNION
select field 1, field 2, '' as field 3, field 4 from table B

If that sentence means that the content of field 1 in table a or table b is not duplicated

select isnull (a.field1, b.field1), isnull (a.field2, b.field2), a.field3, b.field4
from table A a full join table B b
on a. field 1 = b. field 1

lancelot0229

sele aaa, bbb, ccc, space (10) as ddd from table a;
union;
sele aaa, bbb, space (10) as ccc, ddd from table b

nby000

Can use functions