SQL Count(*) = 0?

[rapante]

Ein einfacher Subselect sollte das tun was du möchtest:

Code:

SELECT id,
       (SELECT COUNT(*) FROM log$object_events WHERE (object$ID = object.id) AND (event = 'OBJECT_DISABLED')) AS eventcount 
FROM object;