|
|
发表于 2021-4-21 10:43:22
|
显示全部楼层
<select id="selectProcedureList" resultType="com.xchinfo.erp.entity.jj.ScgzmxEO">
select a.*,b.scsl,c.gxnr from (
select ifnull(sum(hgs),0) as hgs,gxid,gxmc from mes_scgzmx where mid= #{ddmxid} and gxbh=#{workStationType} group by gxid order by gxid asc ) as a
left join mes_scgz b on b.ddmxid= #{ddmxid}
left join ( select gxnr, gxxh from jj_gxmx where gxId = (
select gxId from jj_gxb where ljhId=(select ljid from mes_scgz where ddmxid= #{ddmxid})
) and gxbh=#{workStationType} ) c on a.gxid=c.gxxh
where a.hgs < b.scsl
</select> |
|
[复制链接]
