How to use where clause with IN statement for two differnt columns

[elan2799]

I am using a statement to using where clause but it is returing error. Below is the statment i am using

select * from (select
a.QST_ID as qID,
a.QST_VER_NO as ver_no,
a.MI_OPTNS_ID as index1,
b.MI_OPTNS_TXT as value
from QST_MI_OPTNS_LINK_TBL a INNER JOIN MI_OPTNS_LIST_TBL b on
a.MI_OPTNS_ID = b.ID)
where (qID, ver_no) in ( (2973,3), (2983,4))

I am receiving syntax error near where statement.

[Reeza]

You can't specify the where clause like that. 

You meed to do so,etching like the following. This assumes that you don't need specific combinations. 

where qid in (value list) and/or ver_no in (value list). 

[elan2799]

Hi,

Each qid column has 1 to 7 version ids. I want to extract the Qid 2973 for
version 3 & 2983 for version 4 alone but this 2973 ,2983 matches multiple
version. If u want I can send sample datasets.

CHEERS,
ELA

[Reeza]

You can't specify the where clause like that. 

You meed to do so,etching like the following. This assumes that you don't need specific combinations. 

where qid in (value list) and/or ver_no in (value list). 

[Patrick]

I believe below is the valid SQL logic for what you're after

  select
    a.QST_ID as qID,
    a.QST_VER_NO as ver_no,
    a.MI_OPTNS_ID as index1,
    b.MI_OPTNS_TXT as value
  from 
    QST_MI_OPTNS_LINK_TBL a 
    INNER JOIN 
    MI_OPTNS_LIST_TBL b 
    on
      a.MI_OPTNS_ID = b.ID
      and 
        (
          a.QST_ID=2973 and a.QST_VER_NO=3
          or
          a.QST_ID=2983 and a.QST_VER_NO=4
        )

[Ksharp · Accepted solution]

where (qID, ver_no) in ( (2973,3), (2983,4))

----->>

where  catx(' ',qID, ver_no) in ( '2973 3', '2983 4')

[Patrick]

@Ksharp

Concatenation works of course but it's also certainly the least performant option. 

[Ksharp]

Patrick,

Agree. But it is more readable, isn't it ?