COunt problem

From: Kean Jacinta <jacintakean_at_yahoo.com>
Date: Mon, 13 Jun 2005 19:28:32 -0700 (PDT)
Message-ID: <20050614022832.87742.qmail@web52907.mail.yahoo.com>

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                 

---

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

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

Received on Mon Jun 13 2005 - 22:33:36 CDT