用友NC 询价 sql 按照商品询价

select cr.currtypename,iv.invcode, cinvclassid,nprice0,nprice1 from prm_tariff h left join bd_corp c on h.pk_corp=c.pk_corp

        left join prm_tariffcurlist b on h.cpricetariffid=b.cpricetariffid

        left join bd_invbasdoc iv on iv.pk_invbasdoc=b.cinvbasdocid

        left join bd_currtype cr on cr.pk_currtype=b.ccurrencyid

        where c.unitcode='公司编码' and iv.invcode='商品编码' and h.dr=0 and b.dr=0

转载于:https://my.oschina.net/u/1385612/blog/504936