New posts in Ansi Sql 92

Insert into ... values ( SELECT ... FROM ... )