SQL & PL/SQL

SELECT pos.EMP,POS.EMPID,

pos.salutationtype as "TITLE",

  pos.FULL_NAME    AS EMPLOYEENAME,

    title.TITLENAME  AS DESGINATION,

    grade.gradename as GRADE,

  div.DIVISIONNAME AS DIVISON,

  dep.NAME         AS DEPARTMENT,

   loc.CITY         AS BRANCH,

   --supervisor name

   --supervisor designation

   extract(day from pos.dateofbirth) as  "dd of dob",

   extract(month from pos.dateofbirth) as "mm of dob" ,

   extract(year from pos.dateofbirth) as "year of dob",

  fun.ROLENAME     AS FUNCTION,

--loc.locationname as "REGION",

extract(day from pos.startdate) as  "dd of doj",

   extract(month from pos.startdate) as "mm of doj" ,

   extract(year from pos.startdate) as "year of DOJ",

   addl.martialstatus as "MARITAL STATUS",

   pos.SEX AS "GENDER",

   pos.bloodgroup AS "BLOOD GROUP",

   pos.EMAIL AS "e-MAIL",

FROM posemployees pos

LEFT JOIN premployeeaddl addl

ON pos.employeeid=addl.employeeid

LEFT JOIN prdivision div

ON addl.DIVISIONID = div.DIVISIONID

LEFT JOIN SCMDEPARTMENTS dep

ON addl.DEPARTMENTID = dep.DEPARTMENTID

LEFT JOIN prrole fun

ON addl.ROLEID = fun.ROLEID

LEFT JOIN scmlocations loc

ON addl.LOCATIONID = loc.LOCATIONID

LEFT JOIN prtitle title

ON addl.TITLEID = title.TITLEID

LEFT JOIN prgrade grade

ON addl.gradeid=grade.gradeid

WHERE pos.startdate BETWEEN :startdate AND :enddate;

IN THE ABOVE QUERY I HAVE TO ADD THE SUPERVISOR NAME AND DESIGNATION,

FOR EXAMPLE

--------------------

table structure will be like below

supervisor table:                                                   

Employeemaster tbl

designation details

wit the above query i need to include the supervisor details