title: Multiple columns in subquery using Firebird
body: <p>I'm searching the way to do this in Firebird</p>
  
  <pre><code> SELECT  field1, field2, field3
   FROM table1
   WHERE (field1, field2) IN
              (SELECT fieldA, fieldB
               FROM table2
               WHERE fieldA = 'XXXXX')
  </code></pre>
  
  <p>I have searched a solutions and I found some for others databases but not for Firebird.</p>
  
  <p>Regards</p>