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,department FROM department;
SELECT * FROM `employee'
See Question&Answers more detail:os