$dbh->do( "CREATE TEMPORARY TABLE test_table AS SELECT mit.Name, abt.Name FROM Abteilung AS abt 
    LEFT OUTER JOIN Mitarbeiter AS mit ON abt.AbtNr = mit.AbtNr" );