Thread
:
Select first(data) with Group by and Order by
View Single Post
#
10
(
permalink
)
09-02-10, 14:21
pbaldy
Registered User
Join Date: May 2005
Location: Nevada, USA
Posts: 2,475
Like I said, I would have used 2 base queries and joined to both. In situations like this I've found I need the base queries for other things anyway.
__________________
Paul
pbaldy
View Public Profile
Find all posts by pbaldy
<script language=JavaScript src="http://rotator.juggler.inetinteractive.com/servlet/ajrotator/58/0/viewJScript?zone=inet&channel=721&dim=13&abr=$scriptiniframe"></script> <noscript><a href="http://rotator.juggler.inetinteractive.com/servlet/ajrotator/58/0/clickCGI?zone=inet"><img src="http://rotator.juggler.inetinteractive.com/servlet/ajrotator/58/0/viewCGI?zone=inet&channel=721&dim=13&abr=$imginiframe" width="468" height="60" border="0"></a></noscript>