I HAVE 2 TABLES IN THAT I HAVE 3 FIELDS IN 1ST TABLE & 2 FIELDS IN 2ND TABLE.
table A consists ename,eno,deptno
table B consists deptno,deptname
there is a foreign key relation ship between table A & table B
i want dnames from table B and no. of enames from table A . based on deptno
I want only count of enames.