Nissan 370Z Forum  

Set Theory + IT question

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

Go Back   Nissan 370Z Forum > Nissan 370Z General Area > The Lounge (Off Topic)


Like Tree2Likes
  • 1 Post By 6MT
  • 1 Post By hansoac

 
 
LinkBack Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old 01-27-2013, 05:59 PM   #5 (permalink)
Enthusiast Member
 
Join Date: Apr 2011
Location: Brooklyn Park, MN
Posts: 424
Drives: 04 se-r spec v, 370z
Rep Power: 15
homeryansta will become famous soon enough
Default

Quote:
Originally Posted by XiP View Post
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
__________________

Last edited by homeryansta; 01-27-2013 at 06:03 PM.
homeryansta is offline   Reply With Quote
 

Bookmarks


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Newbie Question... smart key question ellebycul New Forum Member 3 05-01-2011 05:04 PM


All times are GMT -5. The time now is 11:30 AM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.6.0 PL2