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
Update update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268 failed: 1142 [UPDATE command denied to user '334187_hdlns_ms5'@'10.187.248.89' for table 'feed'] in [update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268]
updated 1268 (MySQL User Forums), inserted 30, updated 0, at 2012-06-02 00:11:13
