possible to insert select query results?

[rick_cols]

Thanks.

But the following will only insert col1 of t2 and col1 of t3 both into
one column of t1. If t1 has two columns: col1 and col2, I want to insert col1 of t2 into col1 of t1, and insert col1 of t3 into col2 of t2,
how can we do that?

Well you could ...

insert into t1
select col1 from t2;

insert into t1
select col1 from t2
union all
select col1 from t3;

... that sort of thing