Hi Team Good evening, Need small favour please help me how to update table A using Table B in denodo Tool. Iam getting in sql but in denodo I am unable to get can any one help me please.
like this what using in SQL i need in denodo.
UPDATE B SET B.name=A.name,B.address=A.address from
A
LEFT JOIN
B
ON A.id=B.id where B.name<>A.name or B.address<>A.address
Thanks
Prashanth