how to select latest order from table

Question

i have four table like:

1 clientaddress

2 products

3 ordermaster

4 order details

i want select latest order of client in where condition  

 like client_email=''"  and date= max(date)