日期:2014-05-17 浏览次数:20556 次
select xiadan_ls.ID,xiadan_ls.KCID,xiadan_ls.DJBID,xiadan_ls.GoodsName,xiadan_ls.SpecType,xiadan_ls.Provider,xiadan_ls.remarks_xd,xiadan_ls.Assort,xiadan_ls.Quantity_xd,xiadan_ls.Unit,isnull(xiadan_ls.UnitPrice,0) as xiadan_ls.UnitPrice,xiadan_ls.Time,Storage_kc.Quantity from xiadan_ls left join Storage_kc on xiadan_ls.KCID=Storage_kc.ID
select xiadan_ls.ID,xiadan_ls.KCID,xiadan_ls.DJBID,xiadan_ls.GoodsName,
xiadan_ls.SpecType,xiadan_ls.Provider,xiadan_ls.remarks_xd,xiadan_ls.Assort,
xiadan_ls.Quantity_xd,xiadan_ls.Unit,isnull(xiadan_ls.UnitPrice,0) as UnitPrice,
xiadan_ls.Time,Storage_kc.Quantity from xiadan_ls left join Storage_kc on xiadan_ls.KCID=Storage_kc.ID