you do not have ID column in the Outval Table. Then in this case subquery itself will fail. how can you check in a where clause IN(select id from outval ) table, when Id column itself is not available in the outval table.

Please explain