Use
Select (A.n1+B.n2) As TotCount from (select count(*)n1 from Table1)A, (select count(*)n2 from Table2)B On Fri, Jun 26, 2009 at 5:00 AM, shaunak <shaunak.adgaon...@gmail.com>wrote: > > Guys this is a very basic question but i am not able to find the > solution. Hope somebody comes up with solution for me. > > My requirement is to add the counts of two tables. > > select count(*) from table1 ; it returns 20 > select count(*) from table2; it returns 30 > > Now i want to have result in single query as 50 > > Can this be done in single query ? how ? can somebody help me > > Thanks > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
