|
select fxxx.invoiceno invoiceno,fxxx.contractno contractno,IA_dept.DeptNameAbbr DeptName,IA_team.DeptNameAbbr teamname,IA_employeex.EmployeeName EmployeeName,wangldw.Wangldwmc Wangldw,fxxx.CurrencyCode currency,fxxx.yuanbjfje waibjfje,fxxx.yuanbdfje waibdfje,fxxx.Yuanbyue waibyue,fxxx.jiefje jiefje,fxxx.daifje daifje,fxxx.yue yue,fxxx.payterm payterm,fxxx.jiaodrq jiaodrq,fxxx.expectdays days, fxxx.wangldwbm wangldwbm,fxxx.DeptID DeptID,fxxx.TeamID TeamID,IA_EmployeeX.EmployeeID EmployeeID,IA_dept.deptno deptno,IA_team.deptno groupno,IA_employeex.employeeno empno,fxxx.wangldwbm wanglbm, fxxx.productno productno,pdt.pdtname pdtname from #acct_zhanglfx1 fxxx, acct_wangldw wangldw,im_wareacctr pdt, IA_departmentx IA_dept,IA_departmentx IA_team,IA_employeex where (fxxx.yue <> 0) and (fxxx.DeptID = IA_Dept.DeptID) and (fxxx.TeamID = IA_Team.DeptID) and (fxxx.EmployeeID = IA_EmployeeX.EmployeeID) and (fxxx.wangldwbm = wangldw.wangldwbm) and (fxxx.productno = pdt.acctpdt)order by IA_dept.DeptNo,IA_team.Deptno,IA_employeex.EmployeeNo,wangldw.Wangldwbm,currency,contractno,invoiceno
|