当前位置: 动力学知识库 > 问答 > 编程问答 >

entity sql - EntitySQL 'IN subquery

问题描述:

I have the following T-SQL:

SELECT Cust.[CompanyName]

FROM Customers AS Cust

WHERE

(

Cust.[CompanyName] IN (SELECT CustSQ1.[CompanyName] AS [Customer Company name]

FROM Customers AS CustSQ1

WHERE

(

CustSQ1.Country = 'Argentina' )

) )

How do I do the same in EntitySQL?

网友答案:

I found the solution. Corresponding EntitySQL is: "SELECT Cust.[CompanyName] FROM (SELECT CustSQ1.[CompanyName] FROM Customers AS CustSQ1 WHERE ( CustSQ1.Country = 'Argentina' )) AS Cust"

分享给朋友:
您可能感兴趣的文章:
随机阅读: