possible to insert select query results?

[slimdave]

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