四个表,分别是InventoryClass 存货分类档案
ComputationUnit 计量单位
Inventory 存货档案
FHD 发货单
现在要将发货单玉存货档案连接 他们有主键 A 得到表1
然后将表1和 存货分类档案连接 有主键B 得表2
将表2和计量单位连接 有主键C 得表3
请问如何写比较简单 我写一个脚本 但是感觉有点繁琐 有点乱
得表3;
select a.ccomunitname ,b.* from ComputationUnit a inner join
(select a.cinvcname,b.* from InventoryClass a inner join
( select a.cinvccode,a.ccomunitcode, fahuodan.cdlcode,fahuodan.ddate,fahuodan.cinvcode from Inventory a inner join
(select a.cdlcode,a.ddate,b.cinvcode,a.dlid as adlid
from DispatchList a inner join DispatchLists b
on a.dlid=b.dlid ) fahuodan
on a.cinvcode=fahuodan.cinvcode ) 1
on a.cinvccode=b.cinvccode) 2
on a.ccomunitcode=b.ccomunitcode 3
select a.cdlcode,a.ddate,b.cinvcode,a.dlid as adlid
from DispatchList a inner join DispatchLists b
on a.dlid=b.dlid ) fahuodan 得表1;
select a.cinvccode,a.ccomunitcode, fahuodan.cdlcode,fahuodan.ddate,fahuodan.cinvcode from Inventory a inner join
(select a.cdlcode,a.ddate,b.cinvcode,a.dlid as adlid
from DispatchList a inner join DispatchLists b
on a.dlid=b.dlid ) fahuodan
on a.cinvcode=fahuodan.cinvcode ) 1
得表2;
select a.cinvcname,b.* from InventoryClass a inner join
( select a.cinvccode,a.ccomunitcode, fahuodan.cdlcode,fahuodan.ddate,fahuodan.cinvcode from Inventory a inner join
(select a.cdlcode,a.ddate,b.cinvcode,a.dlid as adlid
from DispatchList a inner join DispatchLists b
on a.dlid=b.dlid ) fahuodan
on a.cinvcode=fahuodan.cinvcode )
on a.cinvccode=b.cinvccode) 2
ComputationUnit 计量单位
Inventory 存货档案
FHD 发货单
现在要将发货单玉存货档案连接 他们有主键 A 得到表1
然后将表1和 存货分类档案连接 有主键B 得表2
将表2和计量单位连接 有主键C 得表3
请问如何写比较简单 我写一个脚本 但是感觉有点繁琐 有点乱
得表3;
select a.ccomunitname ,b.* from ComputationUnit a inner join
(select a.cinvcname,b.* from InventoryClass a inner join
( select a.cinvccode,a.ccomunitcode, fahuodan.cdlcode,fahuodan.ddate,fahuodan.cinvcode from Inventory a inner join
(select a.cdlcode,a.ddate,b.cinvcode,a.dlid as adlid
from DispatchList a inner join DispatchLists b
on a.dlid=b.dlid ) fahuodan
on a.cinvcode=fahuodan.cinvcode ) 1
on a.cinvccode=b.cinvccode) 2
on a.ccomunitcode=b.ccomunitcode 3
select a.cdlcode,a.ddate,b.cinvcode,a.dlid as adlid
from DispatchList a inner join DispatchLists b
on a.dlid=b.dlid ) fahuodan 得表1;
select a.cinvccode,a.ccomunitcode, fahuodan.cdlcode,fahuodan.ddate,fahuodan.cinvcode from Inventory a inner join
(select a.cdlcode,a.ddate,b.cinvcode,a.dlid as adlid
from DispatchList a inner join DispatchLists b
on a.dlid=b.dlid ) fahuodan
on a.cinvcode=fahuodan.cinvcode ) 1
得表2;
select a.cinvcname,b.* from InventoryClass a inner join
( select a.cinvccode,a.ccomunitcode, fahuodan.cdlcode,fahuodan.ddate,fahuodan.cinvcode from Inventory a inner join
(select a.cdlcode,a.ddate,b.cinvcode,a.dlid as adlid
from DispatchList a inner join DispatchLists b
on a.dlid=b.dlid ) fahuodan
on a.cinvcode=fahuodan.cinvcode )
on a.cinvccode=b.cinvccode) 2
from DispatchList a
inner join DispatchLists b on a.dlid=b.dlid
inner join Inventory c on c.cinvcode=b.cinvcode
inner join InventoryClass d on c.cinvcode=d.cinvcode
inner join ComputationUnit e on e.ccomunitcode=c.ccomunitcode