Hi,
When i running this query
select (select count(*) from locations) + (select count(*) from regions) as "Total" from dual ... It's working fine.

But i need to add one more column SUM(Amount) which will fetch the total amount. So i changed the query to
select (select SUM(AMT),count(*) from locations) + (select SUM(AMT),count(*) from regions) as "Total" from dual. I am getting to many values error.

What needs to be done for this?

Try:

select SUM(AMT), count(*)
from
(select amt from locations
union all
select amt from regions)

Hi Jarl

Thnaks A lot it's working now !!!!