Re: I'm Confused

ok

So if it's

select workshop_num

    from workshop join module
    on workshop.module_num = module.module_num

        where module.module_num = workshop.module_num

Is that right?

Is the join needed or is it only used if there are 2 columns from 2 tables in the SELECT?

Thanks

Stephan Bressler <stephan.bressler_at_siemens.com> wrote in message news:aojhgq$n0q$1_at_news.mch.sbs.de...
>
>
> >
> > Module
> > Module_num(PK)
> > Module_name
> > Module_description
> > Module_length
> >
> >
> > Workshop
> > Workshop_num(PK)
> > Workshop_room
> > Workshop_start_date
> > Workshop_finish_date
> > Tutor_id(FK)
> > Module_num(FK)
> >
> > I'm thinking if it's Workshop_num = Module_num then the numbers would
have
> > to be identical.
>
> ... where module.module_num = workshop.module_num
>
>
Received on Wed Oct 16 2002 - 06:42:01 CDT