RE: COunt problem

From: Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Tue, 14 Jun 2005 07:49:10 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF16E6D7@EXCNYSM0A1AJ.nysemail.nyenet>

Kean,

You can do it this way:

Select emp_count, emp_dis_count
>From (

   select count(a.idcode) emp_count
   from emp

     ),
     (

   select count(b.idcode) emp_dis_count
   from emp_dis b
     )

Your method is performing a Cartesian join involving both tables. The result would be bad.

Tom

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kean Jacinta Sent: Monday, June 13, 2005 10:29 PM
To: oracle-l_at_freelists.org
Subject: COunt problem

Hi ,

I am trying to do a count on 2 table at the same time.

select count(a.idcode), count(b.idcode)
from emp a, emp_dis b

The result return are not corrent. Both idcode datatype is number.

Actual table count for emp : 15
Actual table count for emp_dis :25

Thank You
JK

        =09

__________________________________=20

Yahoo! Mail=20
Stay connected, organized, and protected. Take the tour:=20 http://tour.mail.yahoo.com/mailtour.html=20

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 14 2005 - 07:54:20 CDT