Hi,
you could do something like this:
INSERT INTO Company_Name (
employee_details.employee_id
,employee_details.emp_name
,employee_details.emp_address
,company_emplyee.Emp_salary
,company_emplyee.location
,employee_details.status)
SELECT
employee_details.employee_id
,employee_details.emp_name
,employee_details.emp_address
,company_emplyee.Emp_salary
,company_emplyee.location
,employee_details.status
FROM
employee_details
INNER JOIN company_emplyee ON
company_emplyee.employee_id = employee_details.employee_id