Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Advanced join Condition in Enrichment Usage

Level 2
Level 2



We are trying to use the Advanced join as shown above to a temporary table but we are getting Sql error at the time of delivery is trigger

The error shown below screenshot


However, if we use the Simple join it works perfectly

Please help us in understanding how to implement Advance join

Any reference document would also be fine



1 Reply
Level 1
Level 1

Hey Rishabh46,

Can you provide the logs within the Delivery Audit, have you added any additional fields as personalization? Has the delivery been created? Is this error after it was created, or before it hits that activity. Have you enabled any SQL logging? Is so, please provide this so we can look at what tables are throwing this error.