1INSERT INTO table_name(column_list)
2SELECT
3 select_list
4FROM
5 another_table
6WHERE
7 condition;
1INSERT INTO dealer_service_rate (username, groupname, rate)
2SELECT username, groupname, rate FROM sub_dealer_service_rate
3WHERE username='rohaannet'