I have 2 data extensions:
- advisers and account directors (lookup file). Table headers: ADVISOR, ACCOUNT_DIRECTOR, ADVISOR_EMAIL, ADVISOR_PHONE, ADVISOR_BRANCH.
- directors emails (send data). Table headers: ACCOUNT_DIRECTOR, ACCOUNT_DIRECTOR_EMAIL. In the first one each account director may have one or more adviser listed. E.g. account director John has Joe, Marry, Priscilla and Tim as advisers (rows 1, 15, 23 and 24).
I need to email each account director from the second data extension (send data file), a table with this header (all her or his advisors): ADVISOR, ADVISOR_EMAIL, ADVISOR_PHONE, ADVISOR_BRANCH
Basically, I need to pull all advisors associated to every account director.
How can I do this with AMPscript?