title: Querying Same Lookup Table With Multiple Columns
body: <p>I'm a bit confused on this. I have a data table structured like this:</p>
  
  <p>Table: Data  </p>
  
  <pre><code>DataID    Val
  1         Value 1
  2         Value 2
  3         Value 3
  4         Value 4
  </code></pre>
  
  <p>Then I have another table structured like this:</p>
  
  <p>Table: Table1</p>
  
  <pre><code>Col1    Col2
  1       2
  3       4
  4       3
  2       1
  </code></pre>
  
  <p>Both columns from Table1 point to the data in the data table. How can I get this data to show in a query? For example, a query to return this:</p>
  
  <p>Query: Query1</p>
  
  <pre><code>Column1    Column2
  Value 1    Value 2
  Value 3    Value 4
  Value 4    Value 3
  Value 2    Value 1
  </code></pre>
  
  <p>I'm familiar enough with SQL to do a join with one column, but lost beyond that. Any help is appreciated. Sample sql or a link to something to read. Thanks!</p>
  
  <p>PS: This is in sqlite</p>