Process 1 when you describe it truly is your greatest bet even though. It appears to be like a little terse mainly because of the naming scheme plus the quick aliases but... aliasing is your Buddy when it relates to joining the same table multiple times or using subqueries etcetera. https://nigelf019vsq6.illawiki.com/user