Learn "JOINS" with Examples(Questions)

EMP_MASTER :

EMP_NO FNAME MNAME LNAME DEPT DESIG BRANCH_NO

BRANCH_MASTER :

NAME BRANCH_NO

CONTACT_DETAIL:

CODE_NO PHONE_NUMBER ADDRESS

1. List the employee details along with branch names to which they belong..
2. List the employee details of only those employees who belong to the Administration department along with branch names to which they belong. 
3. List the employee details along with the contact details using Right outer join. 
4. List the employee details along with the contact details using Left outer join.