All pastes #940912 Raw Edit

Syn

public sql v1 · immutable
·published 2008-03-13 11:45 UTC
rendered paste body
SELECT TOP 1 event_IntID  FROM EventsTb EvT  JOIN ActionsTb  AcT ON AcT.action_EventFK = EvT.event_IntID    WHERE AcT.action_IntID IN      (      SELECT TOP 1 action_IntID        FROM ActionsTb        WHERE AcT.action_EventFKD = EvT.event_IntID      )