Method 1 when you explain it is your ideal guess although. It seems a little bit terse as a result of naming plan along with the shorter aliases but... aliasing is your friend when it involves joining a similar table multiple times or working with subqueries and so forth.Therefore, the e-mail distribution teams I need are/needs to be the Universal