Forum Discussion
Merge/Join and Query Folding
Hi all I am trying to fold a query which joins two tables I have attempted Table.NestedJoin and Table.Join, trying both LeftOuter and Inner. When I look at the diagnostic steps, both left an...
Thanks Alexis. They were coming from the same source.
My issue was that I changed column datatype on the table I was joining. Removing this step allowed folding to occur. I changed the datatype after that step! All fixed..!
Just in case you're missing something simple, are the two tables coming from the same source? (Query folding isn't possible if the two queries can't be combined into a single SQL statement evaluated at a single source.)
Thanks Alexis. They were coming from the same source.
My issue was that I changed column datatype on the table I was joining. Removing this step allowed folding to occur. I changed the datatype after that step! All fixed..!