SELECT
    each_req1.`serial_num`, each_req1.`status`, each_req1.`date_created`, each_req1.`date_acted`,
    transactions1.`serial_num`, transactions1.`trans_date`
FROM
    `each_req` each_req1,
    `transactions` transactions1
WHERE
    each_req1.`effective_sn` = transactions1.`effective_sn` AND
    each_req1.`serial_num` = transactions1.`serial_num` AND
    each_req1.`status` = 'resolved'
ORDER BY
    transactions1.`serial_num` ASC,
    each_req1.`serial_num` ASC