Guest User

Untitled

a guest
May 26th, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.52 KB | None | 0 0
  1. select
  2. t1.id
  3. ,t1.name
  4. ,t3.description
  5. ,t3.amount
  6. from
  7. table1(nolock) t1
  8. join table2(nolock) t2 on t1.t2_id=t2.id
  9. join table3(nolock) t3 on t2.t3_id=t3.id
  10.  
  11. t1.id | t1.name | t3.description | t3.amount
  12. 1 TEST TEST DESC. 1 | 100
  13. 1 | TEST | TEST DESC. 2 | 200
  14.  
  15. t1.id | t1.name | TEST DESC. 2 | TEST DESC. 2
  16. 1 | TEST | 100 | 200
Add Comment
Please, Sign In to add comment