aspose file tools*
The moose likes JDBC and the fly likes simple join that drives me nuts Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "simple join that drives me nuts" Watch "simple join that drives me nuts" New topic
Author

simple join that drives me nuts

Peter Primrose
Ranch Hand

Joined: Sep 10, 2004
Posts: 755
can anyone assist me with this one:
I am trying to convert this table:

thanks


to this:

stu derby
Ranch Hand

Joined: Dec 15, 2005
Posts: 333


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.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: simple join that drives me nuts