视图怎样用SQL查询两张表的数据

SQL：
select '' as PARENT,'' as LASTMODIFIED,'' as FORMNAME,'' as STATE,'' as AUDITUSER,'' as AUDITDATE ,'' as AUTHOR,'' as AUTHOR_DEPT_INDEX,'' as CREATED,'' as FORMID,'' as ISTMP,'' as VERSIONS ,'' as APPLICATIONID,'' as STATEINT,'' as STATELABEL,'' as AUDITORNAMES,'' as LASTFLOWOPERATION ,'' as LASTMODIFIER,'' as DOMAINID,'' as AUDITORLIST,'' as STATELABELINFO,'' as PREVAUDITNODE ,'' as PREVAUDITUSER ,ITEM_封面项目名称,ITEM_项目类型,ITEM_填报时间,ITEM_流程状态 from(select ID,ITEM_封面项目名称, '现代渔业示范基地' as ITEM_项目类型,a.CREATED as ITEM_填报时间,a.STATELABEL as ITEM_流程状态 from tlk_现代渔业示合同填报 a union select ID,ITEM_封面项目名称, '水产种苗推进工程' as ITEM_项目类型,b.CREATED as ITEM_填报时间,b.STATELABEL as ITEM_流程状态 from tlk_水产种苗合同填报 b ) c where ITEM_流程状态 like '%结束%' order by ITEM_项目类型,ITEM_填报时间 desc

数据库查询结果：

视图显示结果：

一样的哇
写SQL语句就好了

var sql = "select a.ID,a.DOMAINID,a.FORMID,a.ITEM_APPNO,b.item_pwp_line from TLK_PWP a inner join TLK_PWP_DETAILED b on a.ID = b.PARENT ";
sql;

回复 2# lumi

用的是union，如果两张表的id一样，会有影响不？

不建议有重复的系统字段，不会有影响

Q上联系。可以结贴