SELECT a.Member_Id, a.Name, a.email, b.Subject, b.Message ;
FROM TableA a, TableB b ;
WHERE a.member_id = b.Member_Id ;
ORDER BY 1, 4, 5

Note the use of column numbers to specify the order.

Regards
Mark