This too is giving me duplicates... I don't need every line from the left table - only distinct IDs.

My SQL 2014 box doesn't like this at all.

This gives me duplicates now that I look a little bit harder.

Thanks J,

I'll try this out tomorrow and look at the usage.

Yeah, Steve - when I'm looking at something like this I definitely know where the cutoff point is in my head. I can translate the requirement only so far and...

Thank you Steve - I was having a hell of a time trying to figure out the join that didn't have a join in the CTE. Are there any resources...