Hi, I hope you can help. I have a LEFT join as part of my JOIN transformation, and although the job runs to completion, when I try to open the results for the temporary work table the following error is displayed: Unable to execute query: SQL passthru expression contained these errors: ERROR: Correlated reference to column CourtesyTitleID is not contained within a subquery. If I change the join to an INNER join it works. I am connecting to our MS SQL Server 2012 database via ODBC. Any ideas? Cheers!
... View more