How to use the ISEMPTY function

user_15848951 0
Viewed 79

I am learning SQL and using Myworkbench to do so. The error is pointing to the isempty function. Where am I going wrong?

SELECT a.ParcelID, a.PropertyAddress, b.ParcelID, b.PropertyAddress, 
isempty(a.propertyAddress,b.propertyAddress) 
FROM portfolioproject.nashvillehousing a
join nashvillehousing b
on a.ParcelID = b.ParcelID
and a.UniqueID <> b.UniqueID
where a.PropertyAddress = '';
mysql sql
1 Answers

You should use COALESCE

SELECT a.ParcelID, a.PropertyAddress, b.ParcelID, b.PropertyAddress, 
COALESCE(a.propertyAddress,b.propertyAddress) 
FROM portfolioproject.nashvillehousing a
join nashvillehousing b
on a.ParcelID = b.ParcelID
and a.UniqueID <> b.UniqueID
where a.PropertyAddress = '';
user_51935360
Related