SELECT act.*, att.ATT_COUNT
FROM S_EVT_ACT act
    LEFT OUTER JOIN (SELECT PAR_ROW_ID, COUNT(*) AS ATT_COUNT
        FROM S_ACTIVTY_ATT
        GROUP BY PAR_ROW_ID ) AS att ON (act.ROW_ID = att.PAR_ROW_ID)