>Select Qlp.*,; > EofYr.rsc,; > EofYr.eor,; > EofYr.wgc,; > '2P + DE - DF' as Lrdt,; > EofYr.Amt - ReimbDE.Amt - ReimbDF.Amt AS LCol,; > EofPr.Rdt,; > EofPr.Amt AS RCol; >From Qlp-All Qlp >Left Join (select verlvlkey,; > SUM(Amt) AS Amt,; > MAX(Rsc) AS Rsc,; > MAX(Wgc) AS Wgc; > from EndofYear; > where RDT = '2P'; > GROUP BY verlvlkey) EofYr On EofYr.verlvlkey = Qlp.verlvlkey+'2P'+ Qlp.recordtype; >Left Join (select verlvlkey,; > SUM(Amt) AS Amt; > from Reimbursements; > where RDT = 'DE'; > GROUP BY verlvlkey) ReimbDE On ReimbDE.verlvlkey = Qlp.verlvlkey+'DE'+ Qlp.recordtype; >Left Join (select verlvlkey,; > SUM(Amt) AS Amt; > from Reimbursements; > where RDT = 'DF' > GROUP BY verlvlkey) ReimbDF On ReimbDF.verlvlkey = Qlp.verlvlkey+'DF'+ Qlp.recordtype; >Left Join (select verlvlkey,; > SUM(Amt) AS Amt,; > MAX(Rdt) AS Rdt; > from EndofPeriod; > where RDT = 'DH'; > GROUP BY verlvlkey) EofPr On EofPr.verlvlkey = Qlp.verlvlkey+'DH'+ Qlp.recordtype >>