limit_left_join_to_one_result.sql

gistfile1.txt

// Seen on http://stackoverflow.com/questions/2978726/limit-results-from-joined-table-to-one-row

SELECT * FROM days_off_request AS dor
INNER JOIN days_off_request_status_history AS dorsh
	ON dor.id=dorsh.days_off_request
LEFT JOIN days_off_request_status_history AS dorsh2
	ON dor.id=dorsh2.days_off_request
	AND dorsh2.created_at>dorsh.created_at
WHERE dorsh2.created_at IS NULL