Peter, I'm unfamiliar with the "@d := " section you describe. Is this psudo code or real syntax? thanks, Jeff
-----Original Message-----
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Monday, April 25, 2005 4:17 PM
To: Jeff McKeon
Cc: [email protected]
Subject: Re: Query question
Jeff,
Then do it with 2 queries,
SELECT @d := MAX( datestamp )
FROM table2
WHERE parentID = X;
SELECT *
FROM table2
WHERE parentID = X AND [EMAIL PROTECTED];
PB
-----
Jeff McKeon wrote:
Thanks all but I don't have a mysql version high enough
for subqueries.
Thanks,
Jeff
-----Original Message-----
From: Peter Brawley
[mailto:[EMAIL PROTECTED]
Sent: Monday, April 25, 2005 4:01 PM
To: Jeff McKeon
Cc: [email protected]
Subject: Re: Query question
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
