SELECT r.reciept_no,r.loan_no,r.amount_paid,c.mem_name FROM receipts r, customer c WHERE r.loan_no = c.loan_no AND reciept_no = '$receipt_id'