This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes Oracle/OAS and the fly likes Merging 2 results into one select  :shock: Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Merging 2 results into one select  :shock: " Watch "Merging 2 results into one select  :shock: " New topic
Author

Merging 2 results into one select :shock:

Jordan Smith
Ranch Hand

Joined: Apr 06, 2008
Posts: 89
Hi
I would like this result:

to be with in the same result as:


table JPASSETTAGS has the column tagdate, tagname, assetid
table ASSETPUBLICATION has the column pubid, assetid

Thanks!
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Merging 2 results into one select :shock: