title: Compare subquery result with pair of 2 parameters
body: <p>I need to compare 2 parameters in select query with 2 parameters in subquery.
  Example: </p>
  
  <pre><code>SELECT * 
  FROM pupil 
  WHERE name NOT IN (SELECT name FROM bad_names)
  </code></pre>
  
  <p>This example contains only one parameter to compare. But what if I need to compare subquery result with pair of 2 parameters?
  This will work:</p>
  
  <pre><code>SELECT * 
  FROM pupil 
  WHERE name||lastname NOT IN (
      SELECT name||lastname FROM bad_name_lastname_combinations)
  </code></pre>
  
  <p>So string concatenation is the only way to do this?</p>