Shulou(Shulou.com)06/01 Report--

Query the personnel code according to the cashier account number and the pipeline code.

SELECT * FROM RYXX WHERE DEPTID IN (select DEPTID from XSJLC where SKTNO='049' AND JLBH=150735)

-- Product information under the corresponding counter group

Select B.DEPTID,B.DEPT_NAME,R.PERSON_NAME,R.RYDM,S.NAME,S.SPCODE from BFBHDD.GTSP G,BFBHDD.SPXX S,BFBHDD.RYXX R,BFBHDD.BM B,BFBHDD.RYXX_JXC Y

Where G.SP_ID=S.SP_ID

And G.DEPTID=B.DEPTID

And Y.DEPTID=B.DEPTID

And Y.PERSON_ID=R.PERSON_ID

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.