Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

simple join that drives me nuts

 
Peter Primrose
Ranch Hand
Posts: 755
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
can anyone assist me with this one:
I am trying to convert this table:

thanks


to this:

 
stu derby
Ranch Hand
Posts: 333
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


This will work well only for pairs where both 'U' and 'F' exist; if one or the other is missing, the data from the part that's present will be silently dropped.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic