Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Unique_Key A B
- ____________________________
- ABC 1 2
- BCD 5 6
- DDD 10 11
- Unique_Key C D
- ____________________________
- ABC 6 7
- BCD 8 9
- DDD 100 200
- Unique_Key A B C D
- _________________________________________________
- ABC 1 2 6 7
- BCD 5 6 8 9
- DDD 10 11 100 200
- select
- [A], [C]
- from
- tableA r with (nolock) join tableB l with (nolock) on r.Unique_Key =
- l.Unique_Key
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement