如何使用多个表的连接 [英] How to use join for multiple tables

问题描述

我有一个包括4张桌子的场景



doccode，parentdoccode，gatepasscode是表格中的列



MM.GPVHD其 doccode 在MM.GRHDR中是 gatepasscode

MM.GRHDR其 doccode 在MM.SRBFD中是 parentdoccode

MM.SRBFD其 doccode 在PR.APBFD中是 parentdoccode

PR.APBFD



我有PR.APBFD通过i的doccode我需要获取MM.GPVHD的所有记录



结构从下到上





i试过以下但是可以得到

 选择 * 来自 MM.GPVHD GP 内部 加入 MM.GRHDR GH   GP.DocCode 
 
   （选择 GH.GatePassDocCode 来自 MM.GRHDR GH  inner   join  Qc.QTBFD Q   GH.DocCode 
  in （ select  Q.ParentDocCode 来自 Qc.QTBFD Q  inner   join  MM.SRBFD SR  on  Q.DocCode 
  （选择 SR.ParentDocCode 来自 MM .SRBFD SR 内部  join  Pr.APBFD AP   SR.DocCode 
 =（选择 AP.ParentDocCode 来自 Pr.APBFD AP 其中 AP.DocCode = '  FY13 / API / 1'））））

任何帮助都会很明显



问候，

解决方案

http://stackoverflow.com/questions/15987321/joining-multiple-tables-in-sql [ ^ ]

I have one scenarion including 4 tables

doccode ,parentdoccode,gatepasscode are columns in a table

MM.GPVHD its doccode is gatepasscode in MM.GRHDR
MM.GRHDR its doccode is parentdoccode in MM.SRBFD
MM.SRBFD its doccode is parentdoccode in PR.APBFD
PR.APBFD

and i have doccode of PR.APBFD through i which i need to get all records of MM.GPVHD

structure is going from bottom to top


i tried following but coulldnt get

select * from   MM.GPVHD GP inner join MM.GRHDR GH on GP.DocCode

in(Select GH.GatePassDocCode from  MM.GRHDR GH inner join Qc.QTBFD Q on GH.DocCode
in(select Q.ParentDocCode from  Qc.QTBFD Q inner join MM.SRBFD SR on  Q.DocCode
in(select SR.ParentDocCode from  MM.SRBFD SR  inner  join  Pr.APBFD AP on SR.DocCode
=(select AP.ParentDocCode from  Pr.APBFD AP where AP.DocCode='FY13/API/1'))))

Any help will be appreciable

regards,

解决方案

http://stackoverflow.com/questions/15987321/joining-multiple-tables-in-sql[^]

这篇关于如何使用多个表的连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！