How Can Id Assign Foreign Key Mysqli

I have created at 2 tables. These tables are Department, employee. Now i want to assign foreign key in department table and join with employee table. have any idea?? SELECT id,depa

Solution 1:

create employee table field are- id(primary key),name,dept_id
department table fields are-dept_id(primary key),name

after select the dept_id.give index.

than select the department table and dept_id.than click save button.

Solution 2:

Are you looking for this:-

$query="select emp.name, dep.department from employee emp 
INNER JOIN 
department dep ON 
emp.department=dep.department 
order by emp.name asc";