Actually, I figured out why I was getting an error. I was doing a SELECT * instead of only returning one column from the subquery.

I changed the SQL statement...