From: John Diamond (diamondj at domain indigo.ie)
Date: Sun 02 Sep 2001 - 11:47:00 IST
> > Which means that you will have problems with the query you are trying
> > to run. The reason is that you have not joined the two tables and will
> > get a whole load of seemingly random data back. (Or more accurately
> > the cross product.) Assuming of course you have not left out the join
> > for brevity.
>
> > To do what you require, I would suggest trying the following
> > query:
> > SELECT c.Name,mostrecent=MAX(d.Date)
> > FROM Customers c, Deliveries d
> > WHERE c.ID=d.Customer_ID
> > GROUP BY c.Name
> > ORDER BY MAX(d.Date)
> >
SELECT c.ID,c.Name,mostrecent=MAX(d.Date)
FROM Customers c, Deliveries d
WHERE c.ID=d.Customer_ID
GROUP BY c.ID, c.Name
ORDER BY MAX(d.Date)
may be better as name may not be unique
john (ole..ouch)
This archive was generated by hypermail 2.1.6 : Thu 06 Feb 2003 - 13:11:56 GMT