Querying Same Lookup Table With Multiple Columns

Posted by dmaruca on Stack Overflow See other posts from Stack Overflow or by dmaruca
Published on 2010-04-02T16:11:19Z Indexed on 2010/04/02 16:13 UTC
Read the original article Hit count: 162

Filed under:
|
|

I'm a bit confused on this. I have a data table structured like this:

Table: Data

DataID    Val
1         Value 1
2         Value 2
3         Value 3
4         Value 4

Then I have another table structured like this:

Table: Table1

Col1    Col2
1       2
3       4
4       3
2       1

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:

Query: Query1

Column1    Column2
Value 1    Value 2
Value 3    Value 4
Value 4    Value 3
Value 2    Value 1

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!

PS: This is in sqlite

© Stack Overflow or respective owner

Related posts about sql

Related posts about sqlite3