Skip to Content
0
Former Member
Nov 20, 2011 at 01:32 PM

Infoset join behavior

25 Views

Dear Experts,

If Transaction data A is left outer joined (A is the the Left part) to transaction data B by 2 fields, and

this join from A finds 2 records in B based on the 2-field joins,

will the infoset list out 2 records like this :

A B B1 B2 B3 $10

A B B1 B2 B4 $15

where A = field in record in Transaction data A and

B, B1, B2, B3, B4 = fields in Transaction data B

and B1 to B4 cannot be joined to A as A does not have similar fields to join with.

?

Please advise.

Thanks!

regards

Bass