Department variety customer sales analysis to logistics

Department variety customer sales analysis to logistics

Select c. Spidjere c. Djbh as c. RQ refield a.spmchrea.spmchchrea.shpggrea.dwjggreca.shpchdreel b.danwbhPowerb.dwmchrewb.dwyuflleg.b.kehulbC.pihaogere e.sxrqrec.picifuc.shljj.sjj.pckhdjjjjjjje.shl as' including tax cost', e.hsjejjc.mljcec.ml2 as business gross profit, d.bmfinally d.thfsjj.kman D.ywyrec b.ywy as' correspond to salesman', f.dwmch as supplier, e.fukfs as' payment method for incoming goods', d.fukfs as' payment method for sales', f.cglxmeme f.typewriting cgMagnea.spcglxmema.cgy.ywlxr

Into # 1 from spkfk a

Join pf_ckmx c on a.spid=c.spid

Join pf_ckhz d on c.djbh=d.djbh and d.bmfolk 'new products department'

Join mchk b on b.dwbh=d.dwbh and b.dwbh not in (select dwbh from mchk where dwmch=' Shanxi Zhendong Pharmaceutical Logistics Co., Ltd. 'and isxs=' is')

Left join sphwph e on c.pici=e.pici and c.hw=e.hw

Join mchk f on f.dwbh=e.dwbh

Where (c.rq > = '2016-03-01' and c.rq