Multiple column with in keyword

[Shajeel]

Hi My table has composite pk, when i want to select based on one key i write select * from table where col1 = 'val1' and col2 = 'val2' when i have more then one pk like (val1, val2), (val3, val4), ... how can i write select with in so that i can get rows satisfing all the conditions. Shajeel

[Paddy Boyd]

select * from table where col1 in ('val1', 'val2') and col2 in ('val3', 'val4')

[Shajeel]

if will give me four combinations val1 and val3 val1 and val4 val2 and val3 val2 and val4 but i want only two combinations like here i just want first and third condition. Shajeel

[Rana Muhammad Javed Khan]

you can simply use: select * from table where col1 IN('val1' , 'val2') and col2 IN ('val3' , 'val4') it will work... Javed

[Rana Muhammad Javed Khan]

you put dummy data in table then check the query will work fine...

[Shajeel]

suppose i have a table Color Shape Red Cirle Red Square Yellow Square and i want 2 records of (Red, Circle) and (Yellow, Square) your command will return me 3 records out of which i dont want middle one. Thank for taking interest Shajeel