I have the following sql:
PHP Code:
"( select message_board.`date`, admin.* from message_board inner join admin on message_board.id = admin.id where
message_board.name = 'dave' ) union ( select time_spent.`date`, admin.* from time_spent inner join
admin on time_spent.id = admin.id where time_spent.name = 'dave' ) " 
i would like to sort my results by id, job_title and client_name (latter two are in admin) - how would i add this to my sql code?

Thanks.