Method 1 as you describe it truly is your greatest guess though. It appears to be a little terse a result of the naming scheme as well as the shorter aliases but... aliasing is your Close friend when it involves joining exactly the same table multiple times or utilizing subqueries https://nigelf019vsq6.illawiki.com/user