SELECT XXFBRQ ,GPDM ,ZQJC ,YWLX,count(YWLX)

FROM dbo.usrESGXXZYCB A

JOIN (SELECT INBBM,GPDM, ZQJC,ZQSC FROM [10.101.0.201].JYPRIME.dbo.usrZQZB) D

ON  A.INBBM=D.INBBM  and YWLX ='FBT0000000WP'AND XXFBRQ>'2022-01-01' AND XXLYBM = 'FCC00000005E'

WHERE D.GPDM IN ( '000833','000835','000851')   

GROUP BY XXFBRQ ,GPDM ,ZQJC ,YWLX 

ORDER BY XXFBRQ ,GPDM ,ZQJC ,YWLX

SELECT  B.GPDM 股票代码,A.ZBDM,ZBNR,BZSM

FROM [10.101.0.201].JYPRIME.dbo.usrZQZB B JOIN usrESGXXZYCB A IN A.INBBM =B.INBBM 

AND B.ZQLB IN (1,2) AND B.ZQSC IN (83,90) AND YWLX ='FBT0000000WP' AND A.XXLYBM = 'FCC00000005E'

SELECT  *---(补充)

FROM dbo.usrESGXXZYCB A

JOIN (SELECT INBBM,GPDM, ZQJC,ZQSC FROM [10.101.0.201].JYPRIME.dbo.usrZQZB) D

ON  A.INBBM=D.INBBM  

WHERE--(补充)

SELECT  A.ID ,A.ZBDM,A.XXFBRQ,A.JZRQ 

FROM usrESGXXZYCB A

JOIN usrESGXXZYCB B ON A.INBBM = B.INBBM   and A.XXLYBM =B.XXLYBM AND A.JZRQ = B.JZRQ --补充

WHERE --补充