Hi,
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
Thanks
Rishabh
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.
Thanks!
Bhav