Skip to content
Advertisement

How to select result of 2 multi conditional columns

im trying to display a result based on 2 multi-conditional columns. I have 3 columns,One being a client, one of them is Product and one of them is Class. There are multiple products that each have multiple classes. I only want to display the results of specific classes of different products. Eg : Product X has a class of 1,2,3 I only want to see the results of Product X of classes 1 & 2. Product Y has a class of 1,2,3 but i only want to see results of Product Y for 1&3. Im new to SQL,is this something that i would need to use multiple case statements for or will that not work because that only works the result of a column? Or multiple select statements? Thanks in advance for any help! 🙂

Client   Product     Class
 Jeff      X           1
 Bill      X           2
 Sam       X           3
 Wendy     Y           1
 Jane      Y           1
 Tom       Y           2
 Dave      Y           3
------------Result----------
Jeff       X           1
Bill       X           2
Wendy      Y           1
Jane       Y           1
Dave       Y           3

Advertisement

Answer

You should be able to get the results you are looking for by using a where clause with an OR statement.

WHERE (product=‘x’ AND class IN (1,2)) OR (product=‘y’ AND class IN (1,3))
User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement