How to search multiple values in two columns in MS SQL

Question

I have a query which looks like

SELECT * FROM mytable mt
WHERE 1=1
AND mt.column_1 IN (SELECT id FROM employee WHERE salary >10000)
OR  mt.column_2 IN (SELECT id FROM employee WHERE salary >10000)

I know the above query is not looking good even though it is getting my job done. I did google but could not find help. The reason I ask is the actual scenario the 'employee' table is temp table which is filled with data at the upper levels of the strored_procedure and this particular is my final select statement for the procedure.

John Cappelletti · Accepted Answer · 2017-01-12 21:02:23Z

2

I think a simple JOIN would do the trick

SELECT mt.* 
 FROM mytable mt
 JOIN (SELECT id FROM employee WHERE salary >10000) B
   on mt.column_1=B.ID or mt.column_2=B.ID

answered Jan 12, 2017 at 21:02

John Cappelletti

82.3k7 gold badges50 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to search multiple values in two columns in MS SQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related