You would get the same error if you changed IN to = . IN can handle sets of multiple rows from a subquery, but NVL() and = cannot. ... <看更多>

I'm talking about the Oracle and Informix (perhaps some others too) function used to filter out non NULL values from query results (similar to COALESCE in other ... ... <看更多>