I would like to set this condition in a left outer join:
On a(“Service agent”).toString Equals b(“VENDOR´S NUMBER”).toString
And
(a(“Shipping Point/Receiving Pt”).toString Equals b(“Plant w/o freight”).toString
Or
a(“Means of Trans. ID”).toString Equals b(“KFZ w/o freight”).toString)
Could you let us know what do you want to perform ?
If you could provide us with Sample Input data and it’s Expected Output along with a detail of the operation that you are trying to do, we could help you better and provide you with alternate suggestions.