Re: Best way to do this query?

Marshall wrote:

> But suppose I also want to know the id and amount of that particular
> invoice?

Something like this should do...

select * from Invoices A
inner join
(
select invoiceid, max(date) as date1 from Invoices group by customerid ) B
on A.invoiceid = B.invoiceid and
A.date = B.date1

Hope this helps... Received on Mon Jan 15 2007 - 04:18:32 CST