Post reply

select problem

  • January 19, 2009 at 5:41 am

    #94634

    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

    #929179

    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

    #929185

    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