Listing 1: SQL Statement

SELECT "department"."dept_id",
         "department"."dept_name",
         "department"."dept_head_id",
         "employee"."emp_id",
         "employee"."manager_id",   
         "employee"."emp_fname",   
         "employee"."emp_lname",   
         "employee"."dept_id",   
         "employee"."street",   
         "employee"."city",   
         "employee"."state",   
         "employee"."zip_code",   
         "employee"."phone",   
         "employee"."status",   
         "employee"."ss_number",   
         "employee"."salary",   
         "employee"."start_date",   
         "employee"."termination_date",   
         "employee"."birth_date",   
         "employee"."bene_health_ins",   
         "employee"."bene_life_ins",   
         "employee"."bene_day_care",   
         "employee"."sex"  
    FROM "department",   
         "employee"  
   WHERE ( "employee"."dept_id" = "department"."dept_id" )