Neena John
New User
Joined: 20 Nov 2008 Posts: 13 Location: bangalore
|
|
|
|
There are three tables
Current,History and archive.The contents of these tables are consolidated in one table called Full.
I need to write a query in which i need to
sum up the record count of Current,History and archive
For example
SELECT COUNT(*) AS C
FROM CURRENT
UNION
SELECT COUNT(*) AS H
FROM HISTORY
UNION
SELECT COUNT(*) AS A
FROM ARCHIVE;
Now i need to sum up the count values(c,h,a) in the same query.
Can anyone help me on this? |
|