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'))))
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)