아래와 같은식으로 쿼리 할려면 어떻게 해야 하는지요>>?

as temp 이게 안먹나요>?

select * from (

select a,b,c from test

union all

select e,f,g from test2

) as temp

where a not in (select a from temp where a ='111')