select a.id, b.customer_name, a.rma_number, a.rma_desc, a.rma_date, a.control_total as QTY, a.rma_status as status from inv_rmas a left join inv_customers b on a.customer_id = b.id order by a.id desc