SELECT Reciept_no,Receipt_dt,Client_no,Amount,;
Cheque_no,Chq_dt,Remark,Bank_nam ;
FROM Reciept,Client WHERE Client.Client_no=Reciept.Client_no ;
AND bankdepo='Y' AND EMPTY(bankddepono);
AND Chq_dt<=mdate;
ORDER BY Chq_dt,Cheque_no ;