Z.DATEOFDONATION, Z.DONATIONAMOUNT FROM ALUMNUS A, (SELECT * FROM DONATION D LEFT JOIN DONATION_MADE DMON D.DONATIONID = DM.DONATIONID)Z LEFT JOIN CORPORATE C ON C.CORPORATEID = DM.CORPORATEID AND A.ALUMNUSID=DM.ALUMNUSID AND Z.TYPEOFDONATIONS= 'MONETARY