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...