title: Using tuples in SQL in clause
body: <p>Given a database like this:</p>
  <pre><code>BEGIN TRANSACTION;
  
  CREATE TABLE aTable (
      a STRING,
      b STRING
  );
  
  INSERT INTO aTable VALUES('one','two');
  INSERT INTO aTable VALUES('one','three');
  
  CREATE TABLE anotherTable (
      a STRING,
      b STRING
  );
  
  INSERT INTO anotherTable VALUES('one','three');
  INSERT INTO anotherTable VALUES('two','three');
  
  COMMIT;
  </code></pre>
  <p>I would like to do something along the lines of</p>
  <pre><code>SELECT a,b FROM aTable
  WHERE (aTable.a,aTable.b) IN
  (SELECT anotherTable.a,anotherTable.b FROM anotherTable);
  </code></pre>
  <p>To get the answer 'one','three', but I'm getting &quot;near &quot;,&quot;: syntax error&quot;</p>
  <p>Is this possible in any flavour of SQL? (I'm using SQLite)</p>
  <p>Am I making a gross conceptual error? Or what?</p>