remove rows from table having full outer join condition
<p>I have used full outer join condition in my joining query for joining two tables and the sample code is as below</p>

<pre><code>  select * from(
   select TO_CHAR(ROUND(col11)) as today1,TO_CHAR(ROUND(col12)) as today2 from T1
   full outer join 
   select TO_CHAR(ROUND(col21)) as yes1,TO_CHAR(ROUND(col22)) as yes2 from T2
  ) MAIN
   where MAIN.today1&lt;&gt;0 and MAIN.today2&lt;&gt;0 and MAIN.yes1&lt;&gt;0 and MAIN.yes2&lt;&gt;0
</code></pre>

<p>sample output expected as below</p>

<pre><code>  today1         today2         yes1            yes2
  somevalue     somevalue      null             null
   null          null            some value       somevalue
  somevalue     somevalue       somevalue        some value
     0                0               0                0
</code></pre>

<p>I  am trying to <strong>remove rows having all zero</strong> <strong>values</strong> using above where clause but output doubles and also row with zero values apperas. Can I know where I am going wrong. Any help much appreciated.</p>