$dbh->do("
   CREATE TABLE trafficstats
      AS SELECT key, sec.id, sec.hid, 
                name,state,ccs,kbps,mbytes
           FROM sec,bt,stats
          WHERE sec.id       = bt.id
            AND sec.hid      = bt.hid
            AND sec.id       = stats.id
            AND sec.hid      = stats.hid
            AND sec.instance = stats.instance
");