Help Outer joins and union and duplicate rows..

From: <CHEELYM9_at_spanky.badm.sc.edu>
Date: 1997/03/21
Message-ID: <33335C82.46E0_at_spanky.badm.sc.edu>#1/1

Hi oracle Group
[Quoted] Can anybody help me to get ride of duplicate rows. I am using union to get ride of my publicate rows , but I hit a very large table twice causing performance problems. I would like to outer join, but with this I get publicate rows.

exapmle

select a.col1 ,a.col2 ,a.col3
from table_a a, table_b b
where a.col1 = b.col1 non-unique relation and a.col2 > 0

union

select c.col1 ,c.col2 ,c.col3
from table_a c
where c.clo1 is null
and c.col2 >0

I would to use

---

select a.col1 ,a.col2 ,a.col3
from table_a a, table_b b
where a.col1(+) = b.col1
and b.col2 > 0

Can anybody give me hint.
THANKS
kboussif_at_sctcorp.com Received on Fri Mar 21 1997 - 00:00:00 CET