如图为数据集A,里面有三个字段PK_CHDA,CHBM,CHMC
该图为数据集B,里面有三个字段PK_INVBASDOC,INVNAME,INVOCE
问:有什么办法可以将数据集A,数据集B的数据合并,并且只显示三列列名吗?
现在是展示六列列名
你取一个别名了。让两个数据集的列名称完全一样不就行了?
比如
PK_INVBASDOC as PK_CHDA
select PK_CHDA as a, CHBM as b CHMC as c from "BD_CHDA"
UNION ALL
select PK_invbasdoc as a, invname as b,invcode asc from bpm.mdm_invbasdoc where substr(invcode,1,2)in ( 'o1' ,'03')