SQLTeam.com | Weblogs | Forums

SQL query needed

Dear members
I have a Db with two tables where the second table has multi records for the same UID
would you please provide me a query to create a new table from table 1 and table 2 as follow:
T1 columns: user_id, mail
T2 columns uid, first_name , last_name
id = uid
The new table must not contain multi record for the same id

Thanks in advance