含税和不含税发货明细表语句

chenjinyi47

select dispatchlist.cdlcode as 发货单号,dispatchlist.ddate as 发货单日期,dispatchlist.ccuscode as 客户编码,
dispatchlist.cCusName as 客户名称 ,dispatchlist.cSOCode as 订单号,dispatchlists.cInvCode as 存货编码,
inventory.cInvName as 存货名称,inventory.Cinvm_unit as 计量单位,inventory.cInvStd as 存货规格,
dispatchlists.iquantity as 发货数量,dispatchlists.iUnitPrice as 原币无税单价,dispatchlists.iTaxUnitPrice as 原币含税单价 ,
dispatchlists.iNatSum as 价税合计
from dispatchlist inner join dispatchlists on dispatchlist.dlid =dispatchlists.dlid inner join inventory on dispatchlists.cinvcode=inventory.cinvcode where dispatchlists.iquantity>=dispatchlists.iSettleQuantity and dispatchlists.inatsum>=dispatchlists.isettlenum

gubing3370

好象不是太正确啊,执行有错误啊