--说明不清楚,试一下如下?
select a.Batchno,b.StoreHouse,b.StoreSpace,b.InQty,
d.OutQty,[Date]=c.Outdate
from Inware as a inner Join InwareDetail as b on a.id=b.pid
inner Join OutWareDetail as c on b.WareID =c.WareID
inner Join Outware as d on c.id=d.pid
select a.Batchno,b.StoreHouse,b.StoreSpace,b.InQty,
d.OutQty,[Date]=c.Outdate
from Inware as a inner Join InwareDetail as b on a.id=b.pid
inner Join OutWareDetail as c on b.WareID =c.WareID
inner Join Outware as d on c.id=d.pid
*****************************************************************************
A little learning is a dangerous thing!
这样显示的是a的batchno啊,d的batchno不能显示啊!我需要a.batchno等于d.batchno时显示一条,他们不相等时则分开显示。
StoreHouse=IsNULL(x.StoreHouse,y.StoreHouse),StoreSpace=isNULL(x.StoreSpace,y.StoreSpace) ,
x.InQty, y.OutQty,[Date]=IsNULL(x.Indate,y.Outdate)
from
( Select a.Batchno,a.Indate,b.WareID,b.StoreHouse,b.StoreSpace,b.InQty
from Inware as a inner Join InwareDetail as b on a.id=b.pid) as x
full join
( Select a.OutWareCode,a.Outdate,b.Batchno,b.WareID,
b.StoreHouse,b.storeSpace,b.OutQty
from Outware as a inner Join OutWareDetail as b on a.id=b.pid) as y on x.WareID=y.WareID
能留下个联系方式吗?呵呵。
你可以加我QQ:44749914或MSN :msh-125@163.com
谢谢