Quote:
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 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