limit left join
Recently we had to pull a single date from a table of dates during a left join. In fact, we needed the most recent date that matched a particular id. We quickly figured out that a left join does not allow for the use of limits in our case. The Dilemma We did mean in…