January 19, 2009 at 5:41 am
i have 3 tables like this
t1 --->table1
id name
1 jj
2 qq
t2----->table2
id name
1 rr
2 uu
t3---table 3
tableId tableName
1 t1
2 t2
i need the foolwing result
name
jj
uu
January 19, 2009 at 6:35 am
I'm sorry, but I don't understand the structure. What relates one table to another? How would you join table1 to table2 to get the results you want. What does table3 have to do with it?
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
January 19, 2009 at 6:43 am
Completely wild guess at what you are trying to do
Select
Name =
case T3.TableName
When 'T1' then t1.name
When 't2' Then t2.name
End
From t3
inner join t1 on t1.id = t3.tableId
Inner join t2 on t2.id = t3.tableId
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply