title: Combining 2 SQL queries into one single query
body: <p>I need help with a SQL query. I am trying to use 'IN' clause to get results from multiple where conditions.</p>
  
  <p>This is the query:</p>
  
  <pre><code>SELECT ID,LOCALCODE,STRING 
  FROM SSODEV.TRANSLATION 
  WHERE STRINGKEY IN (SELECT DESCRIPTIONKEY 
                      FROM SSODEV.APPFIELD 
                      WHERE APPLICATIONID='a6e60e4d-e9ca-4a48-aa7f-0eb4d40ab260',
                      SELECT DISPLAYNAMEKEY 
                      FROM SSODEV.APPFIELD 
                      WHERE APPLICATIONID='a6e60e4d-e9ca-4a48-aa7f-0eb4d40ab260');
  </code></pre>
  
  <p>However for the above I get an error</p>
  
  <blockquote>
    <p>DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=,;8-aa7f-0eb4d40ab260';INTERSECT, DRIVER=4.13.127`</p>
  </blockquote>
  
  <p>My intention is to get a single query for the below 2 queries</p>
  
  <pre><code>select * 
  from SSODEV.TRANSLATION 
  where stringkey = 'appField.e3c94305-84b4-4190-9040-244429a3c0f0.description'
  
  select * 
  from SSODEV.TRANSLATION 
  where stringkey = 'appField.e3c94305-84b4-4190-9040-244429a3c0f0.name'
  </code></pre>
  
  <p>"stringkey" for query 1 and query 2 comes from table SSODEV.APPFIELD with column names DISPLAYNAMEKEY and DESCRIPTIONKEY. Hence they have to be fetched as well</p>