SELECT * , (SELECT TOP 1 MAX(CorDatum) FROM tblBH_Correspondentie WHERE Cor_Ab_ID=71 AND CorFactuur=tbl.MutFactuur AND Cor_Rel_ID=tbl.Mut_Rel_ID ) AS LastCor ,(SELECT TOP 1 CorOmschrijving + '(' + CorPer + ')' FROM tblBH_Correspondentie WHERE Cor_Ab_ID=71 AND ltrim(CorFactuur)=ltrim(tbl.MutFactuur) AND Cor_Rel_ID=tbl.Mut_Rel_ID AND CorMemo IS NULL ORDER BY CorDatum DESC) AS CorOmschrijving ,(SELECT TOP 1 MAX(CorDatum) FROM tblBH_Correspondentie WHERE Cor_Ab_ID=71 AND ltrim(CorFactuur)=ltrim(tbl.MutFactuur) AND Cor_Rel_ID=tbl.Mut_Rel_ID AND CorMemo IS NOT NULL) AS LastCor ,(SELECT TOP 1 MAX(CorDatum) FROM tblBH_Correspondentie WHERE Cor_Ab_ID=71 AND ltrim(CorFactuur)=ltrim(tbl.MutFactuur) AND Cor_Rel_ID=tbl.Mut_Rel_ID AND CorMemo IS NULL) AS LastCorDatum ,(SELECT TOP 1 Fact_ID FROM tblFacturen WHERE tblFacturen.FactType='N' AND Fact_Ab_ID=71 AND tblFacturen.FactNummer=tbl.MutFactuur AND tblFacturen.Fact_Rel_ID=tbl.Mut_Rel_ID) AS Fact_ID FROM (SELECT SUM(MutBedragEX+MutBTW) AS sBedrag, COUNT(*) AS cnt,MutFactuur,MutTermijn,MutDatum,RelCode,Mut_Rel_ID,RelEmail,RelBedrijf,RelAdres,RelPostcode,RelPlaats,RelAanhef, (SELECT SUM(b.MutRekenBedrag) FROM tblBH_Mutaties b WHERE b.Mut_Ab_ID=71 AND b.MutPartNr=3 AND b.MutSoort IN (7,3) AND b.MutFactuur=tblBH_Mutaties.MutFactuur AND b.Mut_Rel_ID=tblBH_Mutaties.Mut_Rel_ID AND b.MutDatum<='12/31/2013' ) AS sBetaald FROM tblBH_Mutaties LEFT JOIN tblBH_Relaties ON tblBH_Mutaties.Mut_Rel_ID=tblBH_Relaties.Rel_ID WHERE Mut_Ab_ID=71 AND MutPartNr=1 AND MutSoort=2 GROUP BY MutFactuur,MutTermijn,MutDatum,RelCode,Mut_Rel_ID,RelEmail,RelBedrijf,RelAdres,RelPostcode,RelPlaats,RelAanhef) AS tbl WHERE 1=1 AND (sBedrag<>sBetaald OR sBetaald IS NULL) AND NOT (sBedrag=0 AND sBetaald IS NULL) AND tbl.MutDatum<='12/31/2013'