Result of a SELECT into a new table

mysql, sql

Solution

CREATE TABLE tablename AS SELECT field1,field2 FROM othertable;

Problem

Hi does anyone know how to add the result of your SELECT in a new table? ``` SELECT Postcode, Punten1, Punten2, Punten3, Punten4 FROM main_inboedel, ouderdom, levensfase, inkomen, oppervlakte WHERE main_inboedel.Ouderdomnummer = ouderdom.Ouderdomnummer AND main_inboedel.Levensfasenummer = levensfase.Levensfasenummer AND main_inboedel.Inkomennummer = inkomen.Inkomennummer AND main_inboedel.Oppervlaktenummer = oppervlakte.Oppervlaktenummer ```

Original source