select a.字段1, a.字段2, a.字段3, b.字段4 from a join b on a.字段1=b.字段1 and a.字段2 = b.字段2
我这样做的对不对?不过提示FROM中有错误.SELECT t3.FTEAMID AS '班组', ----(任务单汇报或工序汇报的部门) t3.FWORKENDDATR AS '时间',-----(任务单汇报或工序汇报的日期)T3新表
SUM(CASE WHEN t12.FBTIMEHRWORK in (1,2,5,10,40) THEN t22.FFINISHTIME ELSE 0 END) AS '汇总工时',----(汇总任务单及工序汇报的工时和)T1是任务单汇报表(也要分表头T11与表体T12); ---- T2工序汇报表(也要分表头T21与表体T22) ,-------共同点是班组'时间'是相同。 ---ICMORPT (任务单汇报表表头T11) ---ICMORPTENTRY (任务单汇报表表体T12),FWORKENDDATR(完工日期),FTEAMID(班组),FBTIMEHRWORK(工时), ---SHPROCRPTMAIN (工序汇报表表头T21) ---SHPROCRPT (工序汇报表表体T22),FWORKENDDATR(完工日期),FTEAMID(班组),FFINISHTIME(工时) ---FROM ICStockBill t1,ICMORPTENTRY t112,SHPROCRPTMAIN t21,SHPROCRPT t22 FROM ICMORPT T11,ICMORPTENTRY t12,SHPROCRPTMAIN t21,SHPROCRPT t22,T3,ICStockBill t1,WHERE t12.FWORKENDDATR=t22.FWORKENDDATR AND t22.FTEAMID=t12.FTEAMID AND t3.FTEAMID=t22.FTEAMID AND t3.FWORKENDDATR=t22.FWORKENDDATR AND t1.FDate>='********' and t1.FDate<='########' ---AND t4.FStandard=1 --AND t3.FShortNumber in('物料编码1',...,'物料编码n') Group By t3.FTEAMID ,t3.FWORKENDDATR,t3.FBTIMEHRWORK请各位指正,或是提示应该如何处理??在此为谢....
--try: SELECT t3.FTEAMID AS '班组', ----(任务单汇报或工序汇报的部门) t3.FWORKENDDATR AS '时间',-----(任务单汇报或工序汇报的日期)T3新表
SUM(CASE WHEN t12.FBTIMEHRWORK in (1,2,5,10,40) THEN t22.FFINISHTIME ELSE 0 END) AS '汇总工时' FROM ICMORPT T11,ICMORPTENTRY t12,SHPROCRPTMAIN t21,SHPROCRPT t22,T3,ICStockBill t1WHERE t12.FWORKENDDATR=t22.FWORKENDDATR AND t22.FTEAMID=t12.FTEAMID AND t3.FTEAMID=t22.FTEAMID AND t3.FWORKENDDATR=t22.FWORKENDDATR AND t1.FDate>='********' and t1.FDate <='########' Group By t3.FTEAMID ,t3.FWORKENDDATR,t3.FBTIMEHRWORK
select a.字段1, a.字段2, a.字段3, b.字段4
from a join b
on a.字段1=b.字段1 and a.字段2 = b.字段2
t3.FWORKENDDATR AS '时间',-----(任务单汇报或工序汇报的日期)T3新表
SUM(CASE WHEN t12.FBTIMEHRWORK in (1,2,5,10,40) THEN t22.FFINISHTIME ELSE 0 END) AS '汇总工时',----(汇总任务单及工序汇报的工时和)T1是任务单汇报表(也要分表头T11与表体T12);
---- T2工序汇报表(也要分表头T21与表体T22) ,-------共同点是班组'时间'是相同。
---ICMORPT (任务单汇报表表头T11)
---ICMORPTENTRY (任务单汇报表表体T12),FWORKENDDATR(完工日期),FTEAMID(班组),FBTIMEHRWORK(工时),
---SHPROCRPTMAIN (工序汇报表表头T21)
---SHPROCRPT (工序汇报表表体T22),FWORKENDDATR(完工日期),FTEAMID(班组),FFINISHTIME(工时)
---FROM ICStockBill t1,ICMORPTENTRY t112,SHPROCRPTMAIN t21,SHPROCRPT t22 FROM ICMORPT T11,ICMORPTENTRY t12,SHPROCRPTMAIN t21,SHPROCRPT t22,T3,ICStockBill t1,WHERE t12.FWORKENDDATR=t22.FWORKENDDATR
AND t22.FTEAMID=t12.FTEAMID
AND t3.FTEAMID=t22.FTEAMID
AND t3.FWORKENDDATR=t22.FWORKENDDATR
AND t1.FDate>='********'
and t1.FDate<='########'
---AND t4.FStandard=1
--AND t3.FShortNumber in('物料编码1',...,'物料编码n')
Group By t3.FTEAMID ,t3.FWORKENDDATR,t3.FBTIMEHRWORK请各位指正,或是提示应该如何处理??在此为谢....
--try:
SELECT t3.FTEAMID AS '班组', ----(任务单汇报或工序汇报的部门)
t3.FWORKENDDATR AS '时间',-----(任务单汇报或工序汇报的日期)T3新表
SUM(CASE WHEN t12.FBTIMEHRWORK in (1,2,5,10,40) THEN t22.FFINISHTIME ELSE 0 END) AS '汇总工时' FROM ICMORPT T11,ICMORPTENTRY t12,SHPROCRPTMAIN t21,SHPROCRPT t22,T3,ICStockBill t1WHERE t12.FWORKENDDATR=t22.FWORKENDDATR
AND t22.FTEAMID=t12.FTEAMID
AND t3.FTEAMID=t22.FTEAMID
AND t3.FWORKENDDATR=t22.FWORKENDDATR
AND t1.FDate>='********'
and t1.FDate <='########'
Group By t3.FTEAMID ,t3.FWORKENDDATR,t3.FBTIMEHRWORK