您现在的位置是：首页> 数字化系统数字化系统

金蝶云星空多表查询销售员部门信息

2024-03-24 数字化系统浏览量260

简介select a.fid,a.单据编号,a.日期,a.F_QOYB_XSBM,a.F_QOYB_XSY, a.F_QOYB_YCNF, b.FID,c.fid,c.FDEPTID,d.fdeptnamefrom (select t0.fid as fid, t0.FBILLNO as 单据编号,t0.F_QOYB_DATE_RE5 AS 日期,t0.F_QOYB_XSBM AS F_QOYB

select a.fid,a.单据编号,a.日期,a.F_QOYB_XSBM,a.F_QOYB_XSY, a.F_QOYB_YCNF,

b.FID,c.fid,c.FDEPTID,d.fdeptname

from (select t0.fid as fid, t0.FBILLNO as 单据编号,t0.F_QOYB_DATE_RE5 AS 日期,t0.F_QOYB_XSBM AS F_QOYB_XSBM ,t0.F_QOYB_XSY AS F_QOYB_XSY,t0.F_QOYB_YCNF as F_QOYB_YCNF from QOYB_t_Cust100070 t0 ) a

inner join ( select * from QOYB_t_Cust_Entry100293 t1 ) b on a.fid = b.fid

inner join (select * from V_BD_SALESMAN t2 )c on a.F_QOYB_XSBM= c.FDEPTID

inner join V_BD_SALESMAN_L d on c.FSTAFFID=d.FSTAFFID

Tags：

上一篇：金蝶SQL账表开发

下一篇：下一篇：根据当前组织过滤指定的销售组织