I created a job in DI studio. I am joining 3 tables in that job. That job has one SQL JOIN transform. After running this particular transform, when i try to see the data in the temporary target table, it is throwing the below error. Can any one provide solution for this or what will be the cause of the error?
Correlated reference to column "A" is not contained within a subquery