This is more of a methodology or best-practice question.
What I have:
Users data extension
Online stores data extension
They are connected by the
A [User] can have multiple instances of an [Online Store].
The [Online Store] changes status based on whether it is
I want to enter a user into a journey and have all the
Online Stores associated with a user on a list in each email. When a store's status changes they would go into a different portion of the journey.
The questions I have are:
1) would an SQL query allow for a one-to-many relationship that updates the DE on a nightly basis?
2) would using ampscript and filters be a better option than a query