select a.employeID ,a.employName ,a.seat, nvl(b.con,0) from employeInfo a , (select employeID,count(*)as con from serviceLog group by employeID) b
where a.employeID = b.employeID(+)
SELECT i.employeId , i.employeName , i.seat ,count(l.employeId) serviceCount
FROM employeInfo i
LEFT OUTER JOIN serviceLog l
ON i.employeId = l.employeId
GROUP BY i.employeId,i.employeName,i.seat
select
a.employeId,
a.employeName,
a.seat,
count(b.employeId)
from employeInfo a,serviceLog b
where a.employeId = b.employeId(+)
group by a.employeId,a.employeName,a.seat
select a.employeId,a.employeName,a.seat,count(b.employeId) from employeInfo a,serviceLog b
where a.employeId = b.employeId(+)
group by a.employeId,a.employeName,a.seat