取有效期范围内的销售价目表价格原创
比邻星
2人赞赏了该文章
7次浏览
编辑于2024年09月30日 16:36:04
SELECT * FROM T_SAL_PRICELIST A LEFT JOIN T_SAL_PRICELISTENTRY B ON A.FID = B.FID LEFT JOIN T_SAL_APPLYCUSTOMER C ON A.FID = C.FID WHERE getdate()>=B.FEFFECTIVEDATE and getdate()<=B.FEXPRIYDATE AND C.FCUSTID = '' AND A.FSALEORGID = '' AND B.FMATERIALID = ''