Re: Create a table in Mysql with perl

[KurtSchwind]

I agree with the other comments. All you need to do is change your code to:

$dbh->do("DROP TABLE IF EXISTS newtable");
$sql="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";
$sth = $dbh->prepare($sql);
$sth->execute ();
$sth->finish ();
$dbh->disconnect ();

Breaking the statements into 2 distinct calls.