Fw: [ILUG] MySQL question

[John Diamond]

> > 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)