Select Query - Join single match in ascending order (4 replies)
(MySQL.com) Is there anyway to specify that you want to return a single result back from a join, and you want the first result to be a maximum or minium value?
I want to do this:
select * from Table1 a left join ( Select * from Table b order by b.DateCrea