From: Peter Brawley
Date: April 25 2005 8:00pm
Subject: Re: Query question
List-Archive: http://lists.mysql.com/mysql/183096
Message-Id: <426D4C5F.3080009@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Jeff,

Something like ...

SELECT *
FROM table2 AS a
WHERE datestamp = (
  SELECT MAX( b.datestamp )
  FROM table2 AS b
  WHERE a.parentID = b.parentID
);

PB

-----


Jeff McKeon wrote:

>I have a table that contains records that link back to a main talbe in a
>many to one configuration linked by table1.id = table2.parentid
>
>Table1 (one)
>Table2 (many)
>
>I want to pull the latest records from table2 for each record in table1
>where certain criteria applie.
>
>So, if record 100 in table1 links to 5 corresponding records in table2,
>I want to pull the latest record from table2 where table2.parentid = 100
>and table2.user not like 'john'
>
>There is a datestamp field in table2.
>
>I just can't figure out how to do this.
>
>Thanks,
>
>Jeff
>
>
>  
>


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.10.2 - Release Date: 4/21/2005