0

Delta Table A : Member

MemberID , FirstName , HashFN 1 ABC bzh7IbKC0CEqmrPLMY/ExQ==

Delta Table B : MemberHashh

CustomerID , FirstName , HashFN 1 EFG bzh7IbKC0CEqmrPLMY/ExQ==

I have to perform join on delta table on HashFN column

Merge Into MemberHashh T1 Using Membership T2 On T2.HashedFistName == T1.HashFN when Matched then Update Set t1.FirstName=t2.FirstName

I'm using Merge however the update is not happening.

Can anyone suggest how to perform join on Hash values

Alex Ott
  • 80,552
  • 8
  • 87
  • 132

0 Answers0