Hi,

Could you not do this using a MERGE statement?

So using table 'Table 1' as the SOURCE and 'Table 2' as the TARGET?

When MATCHED - Update the Domain column in Table...

Thank you for replying.

My expected output is something like the following:

MemberID Customer First Transaction ...