Re: Dividing two Count(*)'s ??

Fernando Borcel wrote:
>
> How do I perform a query that returns the division between the count of two tables?
>
> That is to say:
>
> Select count(*) / (Select count(*) from Tb2) from Tb2;
>
> Thanks!
>
> Fernando Borcel

You need to qualify each colunm and table... use this method

SELECT COUNT(A.ANYCOLUMN)/COUNT(B.ANYCOLUMN)  FROM TABLE1 A, TABLE2 B Hope this helps

-- 
===========================================================
|Bill Schoonmaker	 email:bill.schoonmaker_at_bsis.com  |
|Oracle DBA		                                  |
|Broadway & Seymour                                       |
===========================================================
|I'm sure the op will send out a message before bringing  |
|production down ... oh sh**                              |
===========================================================