How to use join for multiple tables

See more:

SQL

SQL-Server

SQL-Server-2008

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,