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.) |