PAYMENT_POOL_CREDIT.PAYMENT_POOL_CREDIT_TAX_MONEY as Total_Amount from PAYMENT_POOL_CREDITselect format(PAYMENT_POOL_SADAD.PAYMENT_POOL_SADAD_DATE,'dd/MM/yyyy') as Payment_Date,PAYMENT_POOL_SADAD.PAYMENT_POOL_SADAD_OWNER_MONEY as OW
.* inner join (select BILLNUMBER, Max(CREATEDON) AS LastDatefrom SADAD.MAINBILLDETAILS
group by BILLNUMBER) As LastBill On MB.BILLNUMBER = LastBill.BILLNUMBER