请问大虾,我现在有两张表
表A 结构为 COLUMN1,COLUMN2,COLUMN3
表B 结构为 COLUMN1,COLUMN2SELECT * FROM 表A
COLUMN1,COLUMN2,COLUMN3
A1 A2 A3SELECT * FROM 表B
COLUMN1,COLUMN2
B1 B2
表A 结构为 COLUMN1,COLUMN2,COLUMN3
表B 结构为 COLUMN1,COLUMN2SELECT * FROM 表A
COLUMN1,COLUMN2,COLUMN3
A1 A2 A3SELECT * FROM 表B
COLUMN1,COLUMN2
B1 B2
UNION ALL
SELECT COLUMN1,COLUMN2,''FROM B
union all
select * , column3 = '' from b
union all
select * , null from b
union all
select * , null from b
union all
SELECT *, NULL as COLUMN3 FROM 表B