Re: Returning a list of scheduling non-conflicts ?

How about.....

select a.class_name, a.start_day, a.start_time, b.class_name, b.start_day, b.start_time
from schedule a, schedule b
where a.start_day <> b.start_day and a.start_time <> b.start_time;

raghuvir

Zekmoe <zekmoe_at_aol.com> wrote in article <1998060611032200.HAA20268_at_ladder03.news.aol.com>...
> I need to return a listing of all possable times an event is scheduled
AND all
> other events that don't conflict with each event. As a basic example:
> Comp101 Wed 8:30 start time (Only start times)
> Prog102 Tues 9:00
> English Thus 10 :00
> Comp101 Thus 10:00
> Psyc201 Tues 9:00
> I need to return Comp101 and all classes that don't conflict,Prog102 with
all
> classes that don't conflict,English with all classes that don't etc...
So all
> classes have to be listed with the classes that don't conflict with them.
The
> Class name, Start times and days are all in the same table! Ugg! Any help
with
> this greatly appreciated.
> Bob Maggio
>
Received on Sat Jun 06 1998 - 08:00:00 CDT