Approach 1 while you explain it is actually your very best bet even though. It seems a tad terse as a result of naming plan and the quick aliases but... aliasing is your Pal when it comes to joining the same table a number of times or applying subqueries etcetera. https://hermanno219uso5.wikiexpression.com/user