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: 218
        
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