Hi,
hier mal eine Abfrage, die laufen sollte:
SQL-Code:
select t.name, count(i.issueID) as TotalIssue
from tb_teams t
left join tb_users u on u.fk_teamid = t.teamid
left join tb_issues i on i.fk_userid = u.userid
where
( CONVERT(varchar(8), '26.02.2008 00:00:00', 104) = CONVERT(varchar(8), CreationDate, 104) )
or
( CreationDate is null )
group by t.name
order by t.name
... left join!