Mysql condition not working

Question

this is my query for getting order total for particular date. Here I can't get proper result when using AND (tos.status!='5' or tos.status!='6'). what is the problem in this?

SELECT sum(tot.total) as total 
FROM orders_totals tot, orders tos 
WHERE DATE(tos.`timestamp`) BETWEEN '2013-12-09' AND '2013-12-09' and 
      tot.`order` = tos.id and tot.description='Grand-Total' AND 
     (tos.status!='5' or tos.status!='6')

`(tos.status!='5' or tos.status!='6')` Is always true. Because is either either not 5 or 6. What should the condition do? — juergen d, Dec 09 '13 at 06:33
tell us exactly whats your condition and what you say in your query exactly? — babak faghihian, Dec 09 '13 at 06:42

score 0 · Answer 1 · answered Dec 09 '13 at 07:14

0

Try this:

SELECT sum(tot.total) as total 
FROM orders_totals tot
INNER JOIN orders tos ON tot.`order` = tos.id
WHERE DATE(tos.`timestamp`) BETWEEN '2013-12-09' AND '2013-12-09' and 
      tot.description='Grand-Total' AND tos.status NOT IN (5, 6)

answered Dec 09 '13 at 07:14

Saharsh Shah

28,687
8
48
83

Mysql condition not working

1 Answers1