possible to insert select query results?

[slimdave]

You have to have some definition of what value from t3 goes into the same row as a value from t2 or the whole exercise is meaningless.

insert into t1 (col1, col2)
select t2.col3, t3.col4
from t2, t3
where ... ??? ...