Count with joins is giving null results

Count with joins is giving null results

select count(p.id)
from projects p
join calls cl on p.id = cl.projectId
where p.type=‘subproject’

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.