I want to insert data from table1 into table2 and my own data into table2 in one(the same) query, but it is not working. This is my query
$query='insert into table2(id,name) values("001",select first_name from table1 where table1.id="001")';
Please somebody should show me where I am going wrong with my query,I will be very much pleased.Thank you.