File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Merging 2 results into one select :shock:
Joined: Apr 06, 2008
Mar 09, 2009 13:19:14
I would like this result:
SELECT MAX(tagdate) as lastdate FROM JPASSETTAGS where TAGNAME = 'NY'
to be with in the same result as:
SELECT t.TAGNAME,pubid,COUNT(*) as count FROM JPASSETTAGS t,ASSETPUBLICATION a where a.ASSETID = t.ASSETID GROUP BY t.TAGNAME,pubid ORDER BY 3 DESC
table JPASSETTAGS has the column tagdate, tagname, assetid
table ASSETPUBLICATION has the column pubid, assetid
I agree. Here's the link:
subject: Merging 2 results into one select :shock:
SQL: Retrieve duplicate records
Join condition qucik question
how to execute sqlplus and sql commands using java
Counting identical items in DB
unable to get column values
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014