MYSQL Setting Chronological Order

Question

select guest_frs, guest_sur, town, customer.postcode 
from table1,table2 
where name = "xxxxx"

I need to put names of clients in chronological order on mysql but I'm unsure on how to do this. Help is appreciated. Thanks.

Answer 1

Look at ORDER BY

select guest_frs, guest_sur, town, customer.postcode, yourfield
from table1,table2 
where name = "xxxxx"
order by yourfield ASC