SQL: Invalid use of subquery (Error 1810)

A subquery was used in a place where it wasn't expected. For more information, see SELECT - SQL.