RE: COunt problem
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <jacintakean@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 14 Jun 2005 07:49:10 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Kean Jacinta
Sent: Monday, June 13, 2005 10:29 PM
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
