Try this,
$result = mysql_query("SELECT DISTINCT t.Team Team FROM Teams t");
while ($row=mysql_fetch_array($result))
{
$team1 = $row['Team'];
$query = "INSERT INTO seedtmp3(TRN,Team,Fastest_Time,Venue)
SELECT tt.TRN, t.Team, tt.Fastest_Time, v.Venue FROM Teams t
LEFT JOIN...