Tony,
this works also:
select distinct r1.id, count(r2.id),count(r3.id),count(r4.id)
from r1, r2, r3, r4
where r2.id (+) = r1.id
and r3.id (+) = r1.id
and r4.id (+) = r1.id
group by r1.id
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, March 26, 20
Tony - 8i does have outer joins, the syntax is (+) - intuitive right?
I haven't run this query, but it might give some ideas. Since nobody has
responded yet, maybe it'll provoke the experts ;-)
select
r1.id, r2.count(*), r3.count(*), r4.count(*)
from
(select id from master_tab) r1,
(sel
where
da.id = m.id
and db.id = m.id
Hth,
Jeroen
-Oorspronkelijk bericht-
Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Verzonden: woensdag 26 maart 2003 11:04
Aan: Multiple recipients of list ORACLE-L
Onderwerp: SQL Problem - Merging Result sets
Hi all
I have a question which
Hi all
I have a question which is probably easy for some of you
but it is 21:00 and my mind is not working. Would appreciate
it if someone can point me in the right direction. version is 8i
so no ANSI OUTER JOIN.
I have 4 tables:
master_tab, ID is PK
detail_tab_A, ID is FK
detail_tab_B
