dhanish-jose

## self_join.sql
SELECT a.emp_id, a.name, a.manager_id, b.emp_id, b.name
FROM emp a, emp b
WHERE a.manager_id = b.emp_id;

## right_outer_join.sql
SELECT emp_name, dep_name
FROM emp
RIGHT OUTER JOIN department
on dep_id_pk = dep_id_fk ;

## left_outer_join.sql
SELECT emp_name, dep_name
FROM emp
LEFT OUTER JOIN department
on dep_id_pk = dep_id_fk ;

## inner_join.sql
SELECT emp_name, dep_name
FROM emp
INNER JOIN department
on dep_id_pk = dep_id_fk ;
	SELECT a.emp_id, a.name, a.manager_id, b.emp_id, b.name
	FROM emp a, emp b
	WHERE a.manager_id = b.emp_id;
	SELECT emp_name, dep_name
	FROM emp
	RIGHT OUTER JOIN department
	on dep_id_pk = dep_id_fk ;
	SELECT emp_name, dep_name
	FROM emp
	LEFT OUTER JOIN department
	on dep_id_pk = dep_id_fk ;
	SELECT emp_name, dep_name
	FROM emp
	INNER JOIN department
	on dep_id_pk = dep_id_fk ;