title: multiple columns with multiple values in where clause
body: <p>I am executing a query which has multiple columns in where clause which has multiple values. I know that in SQL you can use IN condition to satisfy and get the correct output. What is the way to do in teradata? </p>
  
  <p>my code in Oracle looks like this:</p>
  
  <pre><code>select td.country_code,td.phone_num 
  from telephone_directory td 
  where (td.country_code, td.phone_num) in ((91,1234567890),(44,1020304050),(1,998877446655))
  </code></pre>
  
  <p>This prints out the exact result i.e. 3 rows</p>
  
  <p>My query in teradata looks like this</p>
  
  <pre><code>select country_code ,phone_num  
  from telephone_directory 
  where (country_code in (91, 44, 1) and phone_num in( 1234567890, 1020304050, 998877446655)
  </code></pre>
  
  <p>This however returns more rows:</p>
  
  <pre><code>country_code  phone_num  
  91            1234567890
  91            1020304050
  44            1020304050
  1             998877446655
  </code></pre>
  
  <p>NOTE: The combination of country_code and phone num is not unique. </p>
  
  <p>Is there a way to filter it out in teradata like that in ORACLE?</p>