SQL/Joins.sql at main · kprsnt2/SQL · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
select employee.e_name, employee.e_dept, dept.d_name, dept.d_location
from employee
inner join dept
on employee.e_dept=dept.d_name

select employee.e_name, employee.e_dept, dept.d_name, dept.d_location
from employee
left join dept
on employee.e_dept=dept.d_name

select employee.e_name, employee.e_dept, dept.d_name, dept.d_location
from employee
right join dept
on employee.e_dept=dept.d_name

select employee.e_name, employee.e_dept, dept.d_name, dept.d_location
from employee
full join dept
on employee.e_dept=dept.d_name

update employee set e_age=e_age+10
from employee join dept on employee.e_dept=dept.d_name where d_location='Hyderabad';
select * from employee

delete employee from employee join dept on employee.e_dept=dept.d_name where d_location='Hyderabad';