Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  Tough problem

Author  Topic  jlopes Starting Member 1 Post Posted - 2012-01-19 : 17:35:21 I have a table that contains two columns that are id's to rows in two other tables normal enough. The problem table A col 1 access table B which has two columns with id's to two more tables. The second column in table is to stay in sync with the first column. I want to get rows based on the data in the two columns f table A from the other tables. I'd like something like A.column1_id.C.column_data, were A.column1 takes me to table C etc for table B. select A.column1_id, A.column2_id, B.column1_id, B.column2_id from myAtable A, myBtable B where A.someOtherColumn = B.someOtherColumn