title: SQLite multiple references to a single column
body: <p>For example</p>
  
  <pre><code>Table1
  id|v1|v2|v3
  1 |10|20|30
  2 |20|30|40
  3 |30|40|50
  
  Table2
  id |a|b|c
  100|2|1|1
  200|1|3|2
  300|3|2|2
  </code></pre>
  
  <p>Table2.a, b and c should be Foreign Keys to Table1.id.</p>
  
  <p>If I try:</p>
  
  <pre><code>CREATE Table2(
  id, a, b, c,
  FOREIGN KEY(a, b, c) REFERENCES Table1(id));
  </code></pre>
  
  <p>I get: "Error: number of columns in foreign key does not match the number of columns in the referenced table"</p>
  
  <p>If I do</p>
  
  <pre><code>CREATE Table2(
  id,
  a REFERENCES(id),
  b REFERENCES(id),
  c REFERENCES(id));
  </code></pre>
  
  <p>I just get: "Error: near "id": syntax error"</p>