05-18-2010 05:26 AM
04-08-2012 11:17 PM
Can you paste the SQL code generated by DI studio ?
From you log, It looks like the join KEY -- A is not in one of these three tables.
04-10-2012 03:31 AM
My guess is that you are mixing inner and outer joins.
in these situations is quite easy to create an invalid join syntax (which I think DI Studio should help to identify...)
08-14-2014 12:18 PM
I have solved this problem by putting the inner join at the end after all the outer joins ....although I dont know why the error happens.