$dbh->do("DROP TABLE IF EXISTS newtable");
$dbh->do("
   CREATE TABLE newtable
   SELECT T.time, T.name, T.last, P.company, P.wife 
     FROM T
     JOIN P ON T.wife = P.wife AND T.company = P.company
");