sort in multiple tables

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.

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'
order by admin.id, admin.job_title , admin.client_name

---

doesn't work - says unknown table admin in order clause

Of course, you shouldn't need any table prefix

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'
order by id, job_title , client_name

---