Error in subquery not causing outer query to fail

The following query doesn't return an error from the SQL engine:

SELECT *

FROM table1

WHERE col1 NOT IN (SELECT col2 FROM table2);

In this case, "table2" doesn't contain a column named 'col2'. But the query still runs and returns empty set.