Merging 2 results into one select :shock:

[Jordan Smith]

Hi
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

Thanks!