SELECT employee.emplyeeName, skill.技能 FROM employee LEFT JOIN skill ON employee.employeeID = skill.employeeID;解释: emplyeeName:员工姓名 employeeID:员工id
觉得这样就可以。emplyee表主键 id,skill表主键id,skillid
应该是主外键关系。 employee 的主键作为skill 表外键的引用. alter table skill add constraint fk_skill foreign key (skill_id) references employee(emp_id);--查询每个员工的skill信息 select * from skill s where exists (select 1 from employee e where e.skill_id = s.skill_id);
skill.技能
FROM employee
LEFT JOIN skill
ON employee.employeeID = skill.employeeID;解释:
emplyeeName:员工姓名
employeeID:员工id
觉得这样就可以。emplyee表主键 id,skill表主键id,skillid
employee 的主键作为skill 表外键的引用.
alter table skill add constraint fk_skill foreign key (skill_id) references employee(emp_id);--查询每个员工的skill信息
select * from skill s where exists (select 1 from employee e where e.skill_id = s.skill_id);