SQL AND OR query

Question

I am trying to select some messages from our customer service queries, WHERE Mmessage owner is ABC, data are LIKE ABCDEF AND message ... AND where the message is either from Customer to CSservice or from CSservice to Customer.

How can I do that?

SELECT Date, From, To, Data 
FROM Ccustomers WITH (NoLock)
WHERE MSGowner = 'ABC' AND Data LIKE '%ABCDEF%' AND 
([From] ='Customer' AND [To] = 'CSservice') OR ([From] ='CSservice' AND [To] = 'Customer') 

ORDER by Date

Plus 1 for the answer by jergen d, you just need an extra set of parentheses around the OR condition. — Whirl Mind, Jan 27 '15 at 10:29

score 2 · Accepted Answer · answered Jan 27 '15 at 10:20

2

SELECT Date, From, To, Data 
FROM Ccustomers WITH (NoLock)
WHERE MSGowner = 'ABC' 
AND Data LIKE '%ABCDEF%' 
AND 
(
   ([From] = 'Customer'  AND [To] = 'CSservice') OR 
   ([From] = 'CSservice' AND [To] = 'Customer')
)
ORDER by Date

answered Jan 27 '15 at 10:20

juergen d

201,996
37
293
362

Thanks a lot. Actually I have figured this out few seconds after posting message :) Still learning SQL :) – Petrik Jan 27 '15 at 11:27

score 0 · Answer 2 · answered Jan 27 '15 at 10:30

Your query was basically correct. But you have to consider that the and connection is "stronger" than the or. To get to your desired output you need to set brackets.

Try this:

SELECT Date, [From], [To], Data 
FROM Ccustomers WITH (NoLock)
WHERE MSGowner = 'ABC' 
AND Data LIKE '%ABCDEF%' 
AND (([From] = 'Customer'  AND [To] = 'CSservice') OR ([From] = 'CSservice' AND [To] = 'Customer'))
ORDER BY Date;

SQL AND OR query

2 Answers2

Linked