选择每个客户的最后时间顺序记录，其中每个客户在许多日期都有许多记录

I am trying to get the latest transaction for each member from a MySQL database where each member may have a different number of transaction records. I also have to link the transaction table to the customers table to ensure I don't get any SPECIAL ORDER records.I am trying to get the latest transaction for e