How do i write this in SQL?

[darkage]

Basically this is the pseudo code I want to write in sql:

For each row in table A
-----Insert row in table B with data from table A

This is what Im trying with:

insert into A (col1, col2, col3) values (select col1 from B, blabla, blabla);

Obviously this doesnt work as the "select col1 from B" returns multiple values.

So how do i do this without triggers in mysql?

Thanks in advance.

[syber]

insert into A (col1, col2, col3)
select col1, col2, col3
from B

[darkage]

Worked perfect.

I knew it could be done, was just not sure on the syntax.

Thanks!