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