多条件WHERE子句返回不必要的行

Question

在下面的存储过程中，我希望返回在Flag列中没有DEL的行。当我得到结果时，DEL行被包括在内。我在WHERE子句中做错了什么（我假设就是这样）？

ALTER PROCEDURE [dbo].[GetAllMessages]
-- Add the parameters for the stored procedure here
@Key varchar(30)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
SELECT message.msg_id,
       message.tenant_id,
       message.sender_id,
       message.recipient_id,
       message.recipient_email,
       message.description,
       message.date_recorded,
       message.filename,
       message.size_bytes,
       message.size_time,
       message.filepath,
       message.Flag,
       message.title,
       message.date_activity,
       member.member_image_url
FROM   message
INNER JOIN member
ON message.sender_id = member.person_id
WHERE sender_id = (SELECT person_id FROM auth_key WHERE key = @Key)
OR recipient_id = (SELECT person_id FROM auth_key WHERE key = @Key)
AND Flag != 'DEL'
END

Answer 1

我怀疑您需要一些额外的paren来以您想要的方式分割逻辑：

WHERE (sender_id = (SELECT person_id FROM auth_key WHERE key = @Key)
OR recipient_id = (SELECT person_id FROM auth_key WHERE key = @Key))
AND Flag != 'DEL'