Is it possible to insert data into two table with one statement like a join with select

ie
insert into module m, course_mod cm (m.mod_code, m.mod_title, m.coord_no, m.year, cm.mod_code ,cm.course_code) values ('com888', 'none', 122322, 1, 'com888', 'e410uj')