I have 2 tables emp and dept. there is a foreign key relationship between these 2 tables.
In emp i have 3 fields and in dept 2 fieldsemp: Dept
Now i want to retrieve Dname from Dept and no of enames from emp. No of enames means just count of enames only
How write a query for this