27,579
社区成员
发帖
与我相关
我的任务
分享
select
DISTINCT a.id as 序号,
a.UniCode as 零件号,
b.ItemName as 名称 ,
b.MinUnit as 单位,
a.Quantity as 数量,
a.price as 价格,
CONVERT(varchar(100),a.ValidTime, 112) as 效期,
a.LotNum as 批号,
d.SuppName as 供应商,
CONVERT(varchar(100),c.OptTime, 112) as 入库时间
from
JS_StorelistTbl a ,JS_SysItemTbl b,JS_InStoTbl c,JS_SupplyTbl d,JS_OutStoTbl e
where
a.UniCode =b.UniCode and a.storeID =28
and
(a.BillNum =c.billnum or a.billnum =e.billnum)
and
a.UniCode ='100000000'
and
a.Quantity > 0
and
c.Supplyid =d.SuppID
and
....