How to select columns in SQL server 2008 using WHERE and IN, having 2 columns in the where clause
I would do something along the lines of 

select * from tbl where col 1 in (x1,x2) and col 2 in (y1,y2)


Unless you are looking for specific combinations such as xy and y1 together, you didn't specify enough in your question.