MySQL doesn't support queries inside queries. I think it's on their TODO list...
SELECT * FROM identifisering as i > WHERE i.identifiseringid=(SELECT MAX(ii.identifiseringid) > FROM identifisering as ii > GROUP BY dprosjekt); "Lars Espelid" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hello, > > I need some help whith a mysql-query. Can anyone help? > Is there a good newsgroup for mysql? > > Identifiseringid is the primary key of the table identifisering and is > autoincrement. > There is also a coloumn named dprosjekt in identifisering and some other > coloumns. > dprosjekt has the same value for several tuples. > For each unike dprosjekt I want to print the record where identifiseringid > is max. > > I tought this would work, but it won't: > > SELECT * FROM identifisering as i > WHERE i.identifiseringid=(SELECT MAX(ii.identifiseringid) > FROM identifisering as ii > GROUP BY dprosjekt); > > also tried: > > SELECT * FROM identifisering as i > WHERE i.identifiseringid IN (SELECT MAX(ii.identifiseringid) > FROM identifisering as ii > GROUP BY dprosjekt); > > When I split the query they work: > > SELECT * FROM identifisering as i > WHERE i.identifiseringid='123'; > > SELECT MAX(ii.identifiseringid) > FROM identifisering as ii > GROUP BY dprosjekt; > > > > Thanks, > > Lars > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php