Hi, we use this table mobile_pos
+---------+---------------------+---------------------+ | team_id | time | geometry | +---------+---------------------+---------------------+ | 3 | 2003-01-28 16:17:06 | 727105 5282634 651 | | 5 | 2003-01-28 16:19:22 | 728220 5282453 944 | | 1 | 2003-01-28 17:08:24 | 728998 5283317 1423 | | 3 | 2003-01-28 18:47:16 | 727805 5288644 772 | | 5 | 2003-01-28 19:34:25 | 727228 5283755 815 | | 1 | 2003-01-29 11:08:24 | 728938 5283467 1467 | +---------+---------------------+---------------------+ how do I get the geometry for every team with every newest time? IF I do something like that, I will get the newest record, but how can I get the geometry of the record? SELECT team_id, MAX(time) FROM SAFETOUR_mobile_pos GROUP BY team_id; Thanks Heiko ps: we use mysql 3.23 -- +++ GMX - Mail, Messaging & more http://www.gmx.net +++ NEU: Mit GMX ins Internet. Rund um die Uhr für 1 ct/ Min. surfen! --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php