select A.GSDM AS 公司,YEAR(A.SWRQ) AS 年,month(A.SWRQ) AS 月,sum(B.CHSL) AS 进货数量 from USWH A join USWB B ON A.DjLsh=B.DjLshWHERE (a.DjState ='审核' or a.DjState ='记帐' )and b.CHDW ='卡'${if(len(公司)==0,"","and A.GSDM in ('"+公司+"')")} ${if(len(月)==0,"","and MONTH(A.SWRQ) in ("+月+")")}GROUP BY A.GSDM, YEAR(A.SWRQ), MONTH(A.SWRQ)