LEFT OUTER JOIN using Join Data Tables

Hi I am trying to accomplish the following:

Using Join Data Table:


But when I try to do this join which should give me everything in Table 1 that does not appear in Table 2, I get the following error:

“RemoteException wrapping System.Exception: Job stopped with an unexpected exit code: 0x000000FF”

Someone please help me with how to accomplish this. Do my tables need a key?

A Left outer Join done with Join DataTable is like:

Join Type: Left
dtLeft.JoinCol = dtRight.JoinCol

in the returned dtJoin Result we get also back the inner join results. But when we filter the dtJoinResult on dtRigtht.JoinCol is empty then we removed the inner join rows and the left outer join rows will remain

This makes sense. Thank you

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.