RE: COunt problem

From: Post, Ethan <Ethan.Post_at_ps.net>
Date: Mon, 13 Jun 2005 22:12:53 -0500
Message-ID: <E5D2567DDF0D03428A15664A78CA473CAE7D77@pscdalpexch02.perotsystems.net>

google "SQL cartesian"=20

-----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 9: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 Mon Jun 13 2005 - 23:18:17 CDT