ovideuss - 10:23 am on Nov 2, 2011 (gmt 0)

SELECT orders.*,MAX(downloads.attempt)
FROM orders
LEFT JOIN downloads on downloads.orderid = orders.id
GROUP BY orders.id
HAVING orders.userid = '123'

Replace orders.id with whatever you want to group by.