pk와fk 그리고 inner join문

use practice;
Create table employees(
employee_id int(50) auto_Increment,
employee_name varchar(50),
employee_age int(100),
 primary key (employee_id)
);
insert into employees(employee_id,employee_name,employee_age) value(1,'김하나',19);
insert into employees(employee_id,employee_name,employee_age) value(2,'안철수',35);
insert into employees(employee_id,employee_name,employee_age) value(3,'문재인',40);

select * from employees;
Create table projects(
project_id int(50) not null primary key,
project_name varchar(100),
project_total varchar(100),
pj_id int,
foreign key (pj_id) references employees(employee_id)

);
insert into projects(project_id,project_name,project_total,pj_id) value(1,'프젝','3명',1);
insert into projects(project_id,project_name,project_total,pj_id) value(2,'프로틴','1명',3);
insert into projects(project_id,project_name,project_total,pj_id) value(3,'프로젝트완성','10명',2);
insert into projects(project_id,project_name,project_total,pj_id) value(4,'실패','4명',1);



select * from projects;
select * from employees;

select project_id, project_name, project_total
from employees
join projects
on employees.employee_id = projects.pj_id
where employee_id = 1;