使用IN子句中的子查询,我是更好地返回大量结果(10,000+行)还是使用表连接来限制结果?例如: innerjoin pm_Properties p on p.PropertyId = u.PropertyId and u.UnitId in (select UnitId from Leases l where l.IsActive = 1)select
我有一个具有以下结构的查询: Id, FROM [dbo].Table2 AS [Extent4]WHERE (Table1.Id = [Extent4].Id2)) AS [C1]此查询结构通常由LINQ使用,而不是以下结构:FROM Table1LEFT OUTER JOIN
(SELECT COUNT(1) AS [A1], [Extent4].Id