Help writing an SQL Script
From: Chuck100 <alan.terry74_at_btinternet.com>
Date: 5 Jul 2004 08:07:50 -0700
Message-ID: <eecdee57.0407050707.1458aae2_at_posting.google.com>
I'm having problems with the output of the following script (I've simplified it):-
Date: 5 Jul 2004 08:07:50 -0700
Message-ID: <eecdee57.0407050707.1458aae2_at_posting.google.com>
I'm having problems with the output of the following script (I've simplified it):-
select a.section,a.user,count(b.number),null
from table a, table b
where.........
group by a.section,a.user
union
select a.section,a.user,null,count(c.number)
from table a, table c
where .......
group by a.section, a.user
The output looks like this:-
Section User col A col b
------- ---- ----- -----
section 1 user A 22 0 0 12 section 2 user d 10 0 0 9
I want the output to look like this:-
Section User col A col bsection 2 user d 10 9
------- ---- ----- -----
section 1 user A 22 12
i.e I don't want a second line reflecting the statement after the union command. I want the entry to appear on the one line. I''m using Report Oracle Reports Builder to do the script
Thanks Received on Mon Jul 05 2004 - 17:07:50 CEST