'How to properly use the update and set function?

Update a.propertyaddress
set propertyaddress = isnull(a.propertyaddress, b.propertyaddress)
FROM `nashville housing data for data cleaning` a
JOIN `nashville housing data for data cleaning` b
   ON a.parcelID = b.parcelID
   AND a.UniqueID != b.UniqueID
WHERE a.propertyaddress is null

I cant figure out what is wrong with this code?

mysql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions