SQL Abfrage, Zählen von n Datensätzen aus 2. Tabelle

[mkinzler]

SQL-Code:

select 
    IssueID, i.Name,  
    Case When (Select COUNT(*) from TB_IssueAttachetFiles Where a.FK_IssueID = i.IssueID) > 0 then 'Yes' else '' end as Attachment
from 
    tb_issues i;