select NOT EXISTS
  (from s where NOT EXISTS (from t where s.id = t.id));