Thursday, April 21, 2011

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.