"schoultzy" <schoultzy@yahoo.com> wrote in message
news:1151350579.170354.171700@i40g2000cwc.googlegroups.com...
> Hello everyone,
>
> I am working with the following code:
>
> select section_master.trm_cde, section_master.crs_cde, crs_title,
> crs_capacity,
> crs_enrollment, section_master.udef_3a_1, monday, tuesday, wednesday,
> thursday, friday, begin_time, end_time, bldg_cde, room_cde,
> name_master.last_name
>
> from section_master left outer join hdx_reg_class_periods on
> section_master.udef_3a_1 = hdx_reg_class_periods.period
> inner join section_schedules on (section_master.crs_cde =
> section_schedules.crs_cde
> and section_master.yr_cde = section_schedules.yr_cde and
> section_master.trm_cde = section_schedules.trm_cde)
> left outer join name_master on section_schedules.professor_id_num =
> name_master.id_num
>
> where section_master.yr_cde = '2006'
> order by section_master.trm_cde, bldg_cde, room_cde,
> section_master.udef_3a_1
>
> Some clarification, section_master.udef_3a_1 holds the class period in
> which a given class occurs. This SELECT statement returns all classes
> and rooms that are taken (currently being used). I would like to turn
> this statement around to get all the classes and rooms that are not
> taken (not currently being used). I also have to take into account
> those course periods that conflict with other course periods. These
> conflicts are listed in a table, hdx_reg_class_period_conflicts, which
> contains to columns: one that lists the course period and one that
> lists the conflict for that period (there can be multiple conflicts for
> a given period). I am hoping that someone out there could help me
> accomplish this as I am a novice when it comes to SQL.
>