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