EMP_MASTER :
EMP_NO FNAME MNAME LNAME DEPT DESIG BRANCH_NO
BRANCH_MASTER :
NAME BRANCH_NO
CONTACT_DETAIL:
CODE_NO PHONE_NUMBER ADDRESS
- List the employee details along with branch names to which they belong..
- List the employee details of only those employees who belong to the Administration department along with branch names to which they belong.
- List the employee details along with the contact details using Right outer join.
- List the employee details along with the contact details using Left outer join.