Hi Tom, i get this error: SQL Error: ORA-00933-00000 - "SQL command not properly ended" when i run this query:
update a
set propertyaddress = nvl2(a.propertyaddress, b.propertyaddress,b.propertyaddress)
from nashvillehousing a
join nashvillehousing b
on a.parcelid = b.parcelid
and a.uniqueid_ != b.uniqueid_
where a.propertyaddress is null
trying to populate property address where its null.
Direct join syntax is unsupported in Oracle Database; use a correlated subquery to fetch the values instead.
For example:
update nashvillehousing a
set propertyaddress = (
select nvl2(a.propertyaddress, b.propertyaddress,b.propertyaddress)
from nashvillehousing b
where a.parcelid = b.parcelid
and a.uniqueid_ != b.uniqueid_
)
where a.propertyaddress is null