我有一个左联接查询。我在where子句中有两个谓词。首先,我将IN运算符与select语句一起使用。在第二个谓词中,我将检查IsActive
列是否为true。但是,我不允许使用&操作员,正如我在下面所做的-我得到一个错误:
&
代码:
select Table1.Id
from Table1
left Join Table2 on Table1.Id = Table2.Table1Id
where Table1.IntColumn in (select Table3.IntColumn
from Table3
where Table1.Id = Table3.Id)
& Table1.IsActive = 1 -- this is not allowed
我做错了什么?
你在找and
吗?
select Table1.Id
from Table1 Left Join
Table2
On Table1.Id= Table2.Table1Id
where Table1.IntColumn in (Select Table3.IntColumn
from Table3
where Table1.Id = Table3.Id
) and
Table1.IsActive = 1)