RE: COunt problem
- From: "Post, Ethan" <Ethan.Post@xxxxxx>
- To: <jacintakean@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 13 Jun 2005 22:12:53 -0500
google "SQL cartesian"=20
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Kean Jacinta
Sent: Monday, June 13, 2005 9: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:
