need help in setting up triggered action to join data from 3 tables.
Tabl1 columns : Cust Id (unique), Active Chk (yes/no)
Tab2 columns: Cust Email, Cust Job Title
Tab 3 Columns: Comments, Cust Email
Scenario: need to update Active Chk to yes in table 1, when Cust job title = 'business" adds data in comments (tab3).
I am using Inner Join in trigger actions, but not getting how to add where clause (job title = business). Any insight in setting up join would be great help!
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
Magnum
hi,
need help in setting up triggered action to join data from 3 tables.
Tabl1 columns : Cust Id (unique), Active Chk (yes/no)
Tab2 columns: Cust Email, Cust Job Title
Tab 3 Columns: Comments, Cust Email
Scenario: need to update Active Chk to yes in table 1, when Cust job title = 'business" adds data in comments (tab3).
I am using Inner Join in trigger actions, but not getting how to add where clause (job title = business). Any insight in setting up join would be great help!
Link to comment
Share on other sites
7 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.