You'll need to use the technique described here:
http://dev.mysql.com/doc/refman/5.0/en/example-maximum-column-group-row.html
-Original Message-
From: Michael Stroh [mailto:st...@astroh.org]
Sent: Monday, July 26, 2010 2:50 PM
To: MySql
Subject: Yet another query question
Hi everyone
Aren't you grouping on IDt?
something like ? :
select t2.IDt,t2.ID,t2.Num,max(t2.version) from table1 as t1, tabl2 as t2
where t1.num=t2.num and t1.state!='new' group by t2.IDt
Cheers,
Geert-Jan
2010/7/26 Michael Stroh st...@astroh.org
Hi everyone and thanks in advance for the help. I have a
Yes, sorry, you are correct. I am actually grouping on that other column. I'll
take a look at this and see if it works for me. Thanks!
Michael
On Jul 26, 2010, at 6:10 PM, Geert-Jan Brits wrote:
Aren't you grouping on IDt?
something like ? :
select t2.IDt,t2.ID,t2.Num,max(t2.version)