On Jun 29, 5:55 am, "faizal mangattil`" <faizmangat...@gmail.com>
wrote:
> 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- Hide quoted text -
>
> - Show quoted text -
I'm guessing you didn't see the post from Mayank, as this is the same
query he posted several days ago.
David Fitzjarrell
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
