Meaningless Drivel is fun!*
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

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:


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
Similar Threads
How many class' are there in JDK?
WARNING: Exception getting SSL Cert Socket Closed
Number of Objects created
Can get the Form Feed "\f" to work!
Oh gosh, i think it's a BUG ?!