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" )