How to Join Tables together in a workflow Query?



This is a followup question to

This is where the information I require currently resides:

savedDataList (from a ListUpdate Action)

has many columns, one of which is the DeliveryID


has the tracking data for opens and clicks


has the the timestamp related to delivered at

The next step I need to take is within a Workflow, I must be able to add a Query that can target the Deliveries for those sent within the last 7 days. With this in hand, I need to do an inner join on this data to my savedDataList to collect the columns for each send that has been logged here. I then need to join my data list with the trackingLogRcp to also get the open/click information. Once all of this has been gathered, I need to save these columns into a file so that they can be exported into another system.

I would like some assistance in constructing this query. I cannot seem to join two tables together, (or determine where in the UI I would even select the table to be joined) however I am under the impression it is doable.

Answers (0)