RE: Help with SELECT, JOIN and WHERE query

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_profile u LEFT JOIN team_member t ON u.user_id = t.user_id WHERE t.team_id 2 -Original Message

Get record with MAX() in one column

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 |

Help with SELECT, JOIN and WHERE query

: +-+ |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! - Before posting