---
I meant that you will need at least 2 queries because of that!!
The only solution I can come up with on short notice is get the acctNo
and maxdate, loop over that query and query for the detail.
I'm sure there must be a better solution (involving less querying).
Maybe you can search for that thread in the archives.
> -----Original Message-----
> From: Tony Weeg [mailto:[EMAIL PROTECTED]
> Sent: dinsdag 15 juni 2004 13:20
> To: CF-Talk
> Subject: RE: sql question...
>
> Archive: http://www.houseoffusion.com/lists.cfm/link=i:4:166626
> ---
> yeah, but you have to, its an aggregate query, and if all of
> the contents of the select list, do not reside in the groupy
> by clause, it bombs :(
>
> so, any other ideas...thanks anyway pascal.
>
> ....tony
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
