LEFT JOIN :
SELECT * FROM DEPT D LEFT JOIN EMP E ON D.ID=E.DEPT_ID
RIGHT JOIN :
SELECT * FROM DEPT D RIGHT JOIN EMP E ON D.ID=E.DEPT_ID
INNER JOIN :
SELECT * FROM DEPT D INNER JOIN EMP E ON D.ID=E.DEPT_ID