Select data from another table during insert<>
This question already has an answer here:
Use insert . . . select instead of insert . . . values:
insert into table2 select null, 12, max(odate), 0 from table1;
As a note: you should get in the habit of including the column names in the insert() statement.