AND/ OR precedence mistake. Your query will return all the rows for which
order_status='Not Shipped'
Probably what you want is:
select * FROM OrderTable WHERE submitted=1 AND
dateinserted='1036386000' AND dateinserted='1036502796' AND
( order_status='Shipped' OR order_status='Not Shipped' )
Try grouping your WHERE clauses with parentheses like so:
select * FROM OrderTable WHERE ( submitted=1 AND
dateinserted='1036386000' AND dateinserted='1036502796' AND
order_status='Shipped' ) OR order_status='Not Shipped'
I can never remember whether SQL is left-to-right, right-to-left, or
some
The or part should be in parens. Your bascialy saying grab everything
that has order_status='Shipped' and your date requirements, OR
everything where order_status is equal to 'Not Shipped'...
-- Josh
-Original Message-
From: Aaron Wolski [mailto:aaronjw;martekbiz.com]
Sent: Tuesday,
Hi there,
This worked perfectly for me!
Thanks for the tip - I shall remember this :)
To all who replied - thanks for your help as well.
Regards,
Aaron
-Original Message-
From: Ignatius Reilly [mailto:ignatius.reilly;free.fr]
Sent: Tuesday, November 05, 2002 9:15 AM
To: [EMAIL
Dave Smith [mailto:DavidSmith;byu.net] wrote:
I can never remember whether SQL is left-to-right, right-to-left, or
some other deviant. Using parens is a sure way to guarantee that your
statements are processed in the order you desire.
--Dave
It's easy if you remember: AND is equal to