Hi, I'm wondering what the correct syntax is for a nested correlated
exists subquery?
I have Message and Engagement declarative tables and here is the query i'm
trying to replicate:
select *
from message m
where exists (
select 1 from engagement e
where m.engagement_id = e.id
and exists (
select 1 from engagement ee
where ee.id = 156
and ee.target_id = e.target_id
and ee.candidate_id = e.candidate_id
)
);
Much appreciated!
-tim
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
