sql-server - 如何添加多个 WHERE 条件

Question

我正在尝试检查并将记录从 ITEM 插入到 MIBOMD。仅当 MIITEM 表中存在 ITEM 表中的 ItemID 和 partid 字段时，我才想插入

我使用了下面的代码但是我收到了这个错误信息

Msg 4145, Level 15, State 1, Line 22 An expression of non-boolean type specified in a context where a condition is expected, near 'OR'.

     USE [MITESTCO]
     GO
      INSERT INTO MIBOMD(bomItem, bomRev, bomEntry, partId, lead)
     SELECT ItemID, rev, bomEntry, partid, qty
     FROM ITEM WHERE (partid OR ItemID) IN (SELECT ItemId FROM MIITEM);

Answer 1

您需要将 WHERE 子句从一个 OR 条件拆分为两个。

 USE [MITESTCO];
 GO

 INSERT INTO [MIBOMD] 
   ([bomItem], [bomRev], [bomEntry], [partId], [lead])
 SELECT [ItemID], [rev], [bomEntry], [partid], [qty]
 FROM [ITEM] 
 WHERE [partid] IN (SELECT [ItemId] FROM [MIITEM])
 OR [ItemID] IN (SELECT [ItemId] FROM [MIITEM]);