Set Table Variable using 3 tables

[bookish]

I have read the conversations here with one and two tables. Unfortunately I have 3 tables and I cannot find a way to send an email

Table 1 Attend
Activity ID
FirstName
LastName
Status

Table 2 Incharge
ActivityID
EmailAddress

Table 3 Schedules
ActivityID
(other details)

I can only send to a definite email address (and not to a variable email address) a table like this below, and forward to the correct Incharge email address, but that's a manual task already.
ActivityID FirstName LastName Status

When I used 'Send Email' with 'Join' for tablevariable.ActivityID = Incharge.Emailaddress, the emails sent was equal to the number of records in the tablevariable. So I was obviously doing it wrong.

[Barry]

Hello,

I might not be understanding your question, but if you want to join the tables that contain the Data for the email you can do so in the table variable. It would look like this, if you want to join by the "ActivityID":