insert whit select

[eluser]Unknown[/eluser]
hi, is posible do this with CI?

INSERT INTO table (col1, col2) SELECT col3, col4 FROM table2;

[eluser]GSV Sleeper Service[/eluser]
er, yes.

Code:

$sql = "INSERT INTO table (col1, col2) SELECT col3, col4 FROM table2";
$this->db->query($sql);