换这样
SELECT '表1' AS 类型,ID,FGC_State AS 状态,FGC_AssignTo AS 担当者,
FGC_Creator AS 创建者,FGC_CreateDate AS 创建日期,FGC_LastModifyDate AS 最后更新日期 FROM 表1
UNION ALL
SELECT '外出培训申请' AS 类型,ID,FGC_State AS 状态,FGC_AssignTo AS 担当者,
FGC_Creator AS 创建者,FGC_CreateDate AS 创建日期,FGC_LastModifyDate AS 最后更新日期 FROM 外出培训审批表; |