HI Dagon
How can u use two where clauses in one query is it possible ?
i.e. in ur example :
select t9.plan_id, t9.plan_desc, t9.value, 0
from table9 t9, table11 t11
where t9.plan_id = t11.plan_id (+)
and t9.plan_desc = t11.plan_desc (+)
where t11.plan_id is null
regds
Mangesh