![]() |
Originally Posted by XiP You need to do a right outer join on the ID That won't work if the left set has data that doesn't exist in the right
|
|
LinkBack | Thread Tools | Display Modes |
![]() |
#5 (permalink) |
Enthusiast Member
Join Date: Apr 2011
Location: Brooklyn Park, MN
Posts: 424
Drives: 04 se-r spec v, 370z
Rep Power: 15 ![]() |
![]()
That won't work if the left set has data that doesn't exist in the right set.
The result I want is a 1-1 relationship where the matching only happens in order example: if A{1,1,1,2,2,3,3,3} and B{1,1,2,4} A B -- -- 1 1 1 1 1 null 2 2 2 null 3 null 3 null 3 null null 4
__________________
![]() Last edited by homeryansta; 01-27-2013 at 06:03 PM. |
![]() |
![]() |
Bookmarks |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Newbie Question... smart key question | ellebycul | New Forum Member | 3 | 05-01-2011 05:04 PM |