SELECT
    each_req1.`serial_num`, each_req1.`status`, each_req1.`date_created`, each_req1.`date_acted`,
    transactions1.`serial_num`, transactions1.`trans_date`
FROM
    { oj `each_req` each_req1 INNER JOIN `transactions` transactions1 ON
        each_req1.`effective_sn` = transactions1.`effective_sn` AND
    each_req1.`serial_num` = transactions1.`serial_num`}
WHERE
    each_req1.`status` = 'resolved'
ORDER BY
    transactions1.`serial_num` ASC,
    each_req1.`serial_num` ASC