Posted by Mike C# on 10/02/41 11:51

BTW I think the standard now is if you want to blast your email to 500
relevant newsgroups, you post to them all at once. That way if someone
answers your question it will show up in all the groups at once. So people
won't spend hours trying to resolve an issue that others have already
resolved. And post some DDL.

"schoultzy" <schoultzy@yahoo.com> wrote in message
news:1151350744.132665.276420@r2g2000cwb.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.
>

[Back to original message]