How to compare results of two subqueries in where clause SQLKata #652
Answered
by
sterlyukin
sterlyukin
asked this question in
Q&A
-
I try to compare results of two subqueries in where clause in SQLKata. In SQL it should be like this:
In SQLKata I can compare result of subquery with scalar value:
But I can't compare results of two subqueries this way:
How can I fix it? Maybe I should execute both of the subqueries and only then compare their results? |
Beta Was this translation helpful? Give feedback.
Answered by
sterlyukin
Dec 29, 2022
Replies: 1 comment
-
Solved here - https://stackoverflow.com/questions/74939077/how-to-compare-result-of-two-subqueries-in-where-clause-sqlkata/74948798#74948798 |
Beta Was this translation helpful? Give feedback.
0 replies
Answer selected by
sterlyukin
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Solved here - https://stackoverflow.com/questions/74939077/how-to-compare-result-of-two-subqueries-in-where-clause-sqlkata/74948798#74948798