$dbh->do("
    CREATE TABLE template
       AS SELECT IP, ServerName, Domain, DaysUptime, OS,
                 RAM, OSSP, InstallDate, CPUSpeed, CPUCount,
                 CPUType
            FROM hosts
       LEFT JOIN info
              ON hosts.IP = info.IP
");