I currently left join my customers table on a subquery of the orders table, with the subquery returning ...
stackoverflow.com