MS SQL

Problem With "Where" with boolean type

Please support our MS SQL advertiser: Intel Parallel Studio Home

•

Join Date: Apr 2006

Posts: 88

Reputation: blacklocist is an unknown quantity at this point

Solved Threads: 2

blacklocist blacklocist is offline

Offline

Junior Poster in Training

Problem With "Where" with boolean type

Aug 24th, 2006

Hi all,
Well I am still new to sql to getting better and better with each query. Now this one has me completley stumped.

Here is the query

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
SELECT * FROM MOTORS
WHERE     (CHKCANCEL = '0') AND (DITD IS NULL) AND (CUSTOMERID = '52') OR
                      (CUSTOMERID = '62') OR
                      (CUSTOMERID = '72')
SELECT * FROM MOTORS
WHERE     (CHKCANCEL = '0') AND (DITD IS NULL) AND (CUSTOMERID = '52') OR
                      (CUSTOMERID = '62') OR
                      (CUSTOMERID = '72')

This return 37 rows but there is two rows that have CHKCANCEL = 1

Any Ideas??

Thx

Last edited by blacklocist; Aug 24th, 2006 at 3:25 pm. Reason: Forgot select command in the example

•

Join Date: Apr 2006

Posts: 88

Reputation: blacklocist is an unknown quantity at this point

Solved Threads: 2

blacklocist blacklocist is offline

Offline

Junior Poster in Training

Re: Problem With "Where" with boolean type

Aug 24th, 2006

I used this syntax and it work perfectly.

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
 
USE MTRTRK
SELECT * FROM MOTORS
WHERE CUSTOMERID IN ('52', '72', '62') AND CHKCANCEL = '0' AND DITD IS NULL
use MTRTRK
SELECT * FROM MOTORS
WHERE CUSTOMERID in ('52', '72', '62') and CHKCANCEL = '0' and DITD IS NULL

•

Join Date: Jul 2005

Posts: 483

Reputation: campkev is an unknown quantity at this point

Solved Threads: 19

campkev

Offline

Posting Pro in Training

Re: Problem With "Where" with boolean type

Sep 12th, 2006

the problem with you original query was precedence

what you need is

WHERE (CHKCANCEL = '0') AND (DITD IS NULL) AND( (CUSTOMERID = '52') OR
(CUSTOMERID = '62') OR
(CUSTOMERID = '72'))

•

Join Date: Apr 2006

Posts: 88

Reputation: blacklocist is an unknown quantity at this point

Solved Threads: 2

blacklocist blacklocist is offline

Offline

Junior Poster in Training

Re: Problem With "Where" with boolean type

Sep 13th, 2006

Thanks I need to learn the importance of ( and )
THX!!

•

Originally Posted by campkev

the problem with you original query was precedence

what you need is

WHERE (CHKCANCEL = '0') AND (DITD IS NULL) AND( (CUSTOMERID = '52') OR
(CUSTOMERID = '62') OR
(CUSTOMERID = '72'))