Re: Best way to do this query?
From: Cimode <cimode_at_hotmail.com>
Date: 17 Jan 2007 06:48:15 -0800
Message-ID: <1169045295.148450.70560_at_38g2000cwa.googlegroups.com>
Date: 17 Jan 2007 06:48:15 -0800
Message-ID: <1169045295.148450.70560_at_38g2000cwa.googlegroups.com>
JOG wrote:
> SELECT A.invoiceid, A.customerid, A.date, A.amount, Max(A.date -
> B.date)
> FROM invoices AS A
> INNER JOIN invoices AS B
> ON A.customerid = B.customerid
> GROUP BY A.customerid
I do not see how this query could produce the desired result
Received on Wed Jan 17 2007 - 15:48:15 CET