Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select
- t1.id
- ,t1.name
- ,t3.description
- ,t3.amount
- from
- table1(nolock) t1
- join table2(nolock) t2 on t1.t2_id=t2.id
- join table3(nolock) t3 on t2.t3_id=t3.id
- t1.id | t1.name | t3.description | t3.amount
- 1 TEST TEST DESC. 1 | 100
- 1 | TEST | TEST DESC. 2 | 200
- t1.id | t1.name | TEST DESC. 2 | TEST DESC. 2
- 1 | TEST | 100 | 200
Add Comment
Please, Sign In to add comment