[RESOLVED] SQL SELECT with multiple condition (SQL Server 2017)

[Macronaute]

Hi, I'm sorry to post it here, but I didn't find a place for SQL issues.

I'm trying to extract values from my SQL table for my vb.net app but I have some troubles...

I am trying to do that :

SELECT * FROM "My_table"
WHERE (Condition1 = 1 AND Condition2 = 2) OR
((Condition1 = 2 AND Condition2 = 1) AND (Condition3 =1 OU Condition3 = 2 OU Condition3 = 3)

But when I try it, SQL change the place of my parentheses.

Thank you for your help and sorry if I am in the wrong place...
Have a good day!

[paulg4ije]

You seem to be missing a close bracket.

[techgnome]

Hi, I'm sorry to post it here, but I didn't find a place for SQL issues.

That would be the Database Development section... I've notified the moderators...

-tg

[Macronaute]

I'm sorry, I did it right on SQL Server, but when I copied it in the forum I missed it.

So to be clearer, I write that :

WHERE        (Soldee IS NULL AND Resp_MET = 'TEST' AND Emet <> 'init' AND CPRC = 'NON') OR
                         ((Soldee IS NULL AND Resp_MET = 'TEST' AND Emet <> 'init' AND CPRC = 'OUI') AND (Decision_Q = 'OKAY' OR  Decision_Q = 'REFU' OR  Decision_Q = ''))

And it give me that :

WHERE        (Soldee IS NULL) AND (Resp_MET = 'TEST') AND (Emet <> 'init') AND (CPRC = 'NON') OR
                         (Soldee IS NULL) AND (Resp_MET = 'TEST') AND (Emet <> 'init') AND (CPRC = 'OUI') AND (Decision_Q = 'OKAY' OR Decision_Q = 'REFU' OR Decision_Q = '')

I did not understand why.

[Macronaute]

Thank you, I looked where to post it this morning but I didn't find !

[techgnome]

What are you using to write your queries? SQL Server Management Studio (SSMS)? If so, then you must have a plugin or something because SSMS by itself doesn't change queries.

 (Soldee IS NULL AND Resp_MET = 'TEST' AND Emet <> 'init' AND CPRC = 'NON') OR
((Soldee IS NULL AND Resp_MET = 'TEST' AND Emet <> 'init' AND CPRC = 'OUI') AND (Decision_Q = 'OKAY' OR  Decision_Q = 'REFU' OR  Decision_Q = ''))


(Soldee IS NULL) AND (Resp_MET = 'TEST') AND (Emet <> 'init') AND (CPRC = 'NON') OR
(Soldee IS NULL) AND (Resp_MET = 'TEST') AND (Emet <> 'init') AND (CPRC = 'OUI') AND (Decision_Q = 'OKAY' OR Decision_Q = 'REFU' OR Decision_Q = '')

It looks like what ever it is, is removing the outer parens from the or clause... but I think the whole thing can be simplified anyways...

( (Soldee IS NULL) AND (Resp_MET = 'TEST') AND (Emet <> 'init') ) AND 
  ( 
    (CPRC = 'NON') OR
    ( 
      (CPRC = 'OUI') AND (Decision_Q = 'OKAY' OR Decision_Q = 'REFU' OR Decision_Q = '') 
    ) 
  )

-tg

[si_the_geek]

Thread moved to the 'Database Development' forum


This bit:

AND (Decision_Q = 'OKAY' OR Decision_Q = 'REFU' OR Decision_Q = '')

...can be simplified to:

AND Decision_Q IN('OKAY', 'REFU', '')

[Macronaute]

Thank you for your return, but I just resolve my issue and I am a bit ashamed because of my mistake.

To explain, I was writing in the SQL Server Management Studio (SSMS) but in the "Edit 200 rows" (You can show the SQL pane to wright queries).
Now, I taped it in the "Select 1000 rows" and it works perfectly !

Thank you and excuse me for my silly question

[Macronaute]

Thread moved to the 'Database Development' forum


This bit:

AND (Decision_Q = 'OKAY' OR Decision_Q = 'REFU' OR Decision_Q = '')

...can be simplified to:

AND Decision_Q IN('OKAY', 'REFU', '')

Thank you for it too!