how to insert data from select table with table on another database

Yii 2.0 General Discussions
1

Hi Guys i have two connection database and query bellow

$connection = \Yii::$app->db;

$connection2 = \Yii::$app->db2;

$insert = $connection->createCommand('INSERT INTO table1 (field1, field2, field3)

		select field1,field2,field3 from table2


');

$insert->execute();

Ask, how to table2 to connect $connection2 ?.. because table2 on another database. thanks