Common address joins

Reports using Address 1 Name.ADDRESS\_NUM\_1= Name\_Address.ADDRESS\_NUM
Reports using Address 2 Name.ADDRESS\_NUM\_2= Name\_Address.ADDRESS\_NUM
Reports using Address 3 Name.ADDRESS\_NUM\_3= Name\_Address.ADDRESS\_NUM
Reports using Preferred Bill Address Name.BILL\_ADDRESS\_NUM= Name\_Address.ADDRESS\_NUM
Reports using Preferred Mail Address Name.MAIL\_ADDRESS\_NUM= Name\_Address.ADDRESS\_NUM
Other Alternate Addresses *For example*, if you have more than three purposes: Name.ID=Name\_Address.ID where PURPOSE=' ' (List purpose in between single quotes.)