|
-
I do the following query and I want to get the overall total.
select sum(nw1w2)||' CAA 97' totpas from caa97
where apt='MAN'
union all
select sum(nw1w2)||' CAA 98' totpas from caa98
where apt='MAN'
union all
select sum(nw1w2)||' CAA 99' totpas from caa99
where apt='MAN'
union all
select sum(nw1w2)||' CAA 00' totpas from caa00
where apt='MAN'
union all
select sum(nw1w2)||' CAA 01' totpas from caa01
where apt='MAN'
How do I do this?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote