Approach 1 while you describe it is actually your ideal guess however. It appears to be somewhat terse mainly because of the naming plan as well as shorter aliases but... aliasing is your Good friend when it involves joining the same table various times or using subqueries etcetera. This is https://scottq863jci2.activablog.com/profile