Complex Merging Query In Sql Server 2000

Hello,

I have a Database in a SQL Server 2000 where I have different users
tables with equal fields like this:

id (int)
email (varchar)
name (varchar)
address (varchar)
joinedon (datetime)

I want to merge all the tables in one taking rows with the same email
but taking always the more recent fields based on the 'joinedon' field.
So if I have this four different rows:

Tbl email name address joinedon
--------------------------------------------------------------------------------------------
T1 Join Bytes! johnathan NULL 01/01/95
T2 Join Bytes! NULL barcelona street 01/01/98
T3 Join Bytes! john valencia street 01/01/97
T4 Join Bytes! john Q NULL 01/01/99

And the final row entered in the new table would be

Tbl email name address joinedon
----------------------------------------------------------------------------------------
new Join Bytes! john Q barcelona street 01/01/99

I am trying doing his with union statements, but i am not getting the
real merging of data. Any clue?

Thanks for your help.