Get record with MAX() in one column

2003-01-29 Thread heiko mundle
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

RE: Help with SELECT, JOIN and WHERE query

2003-01-29 Thread heiko mundle
--- Original Message - From: "Victor Pendleton" <[EMAIL PROTECTED]> To: "'heiko mundle'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, January 28, 2003 5:30 PM Subject: RE: Help with SELECT, JOIN and WHERE query SELECT u.user_id FROM user_

Help with SELECT, JOIN and WHERE query

2003-01-28 Thread heiko mundle
esult: +-+ |1002 | |1004 | +-+ Thanks for any hint Kind regards Heiko Mundle -- +++ GMX - Mail, Messaging & more http://www.gmx.net +++ NEU: Mit GMX ins Internet. Rund um die Uhr für 1 ct/ Min. surfen! - Befor