youarewrongbobisright
New Member
I have a very confusing database with a table that holds two values I need in a separate table. Here is my issue:\[code\]Table1- idTable2- id- table1_id- table3_id_1- table3_id_2Table3- id- value\[/code\]I need to go from table1 and do a join that would give me back the value from \[code\]table3\[/code\] in two separate columns. So I want something like this:\[code\]table1.id | table2.id | table2.table3_id_1 | table2.table3_id_2 | X | Y\[/code\]Where \[code\]X\[/code\] and \[code\]Y\[/code\] are the values for the row connected by \[code\]table3_id_1\[/code\] and \[code\]table3_id_2\[/code\] respectively.Possibly make them variables or something so I can filter them in a \[code\]WHERE\[/code\] clause as well?