表名:回单receipt_id、customer_id、receipt_date、receipt_amount
客户将会支付很多账单。我想在收款表中找到每个客户最后一次支付的账单的详细信息。select customer_id,receipt_date from receipt where receipt_id=(select top 1 receipt_id from receipt order
php echo $data['used_receipt'];?php
$receipt = $database->getRows("SELECT DISTINCT SM.receipt_no FROM scheme_master SM Inner join book_issueBI ON BI.book_no = SM.Book_no2 where SM.receipt_no not in (select used_receipt from book_return