Re: I'm Confused

From: Stephan Bressler <stephan.bressler_at_siemens.com>
Date: Wed, 16 Oct 2002 15:00:27 +0200
Message-ID: <aojns5$f6u$1@news.mch.sbs.de>

"Barry Warner" <bwarner_at_blueyonder.co.uk> wrote in message news:_fcr9.23922$jR.9553_at_news-binary.blueyonder.co.uk...
> 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?

Hi,

I'm not very familiar with the new sql syntax. The 'old' would be

    select workshop_num
    from workshop, module
    where module.module_num = workshop.module_num -- do the join

    and workshop.name='i_dont_know';                              -- add.

criteria

The 'new' would be something like

    select workshop_num
    from workshop join module
    on module.module_num = workshop.module_num -- do the join

    where workshop.name='i_dont_know';                    -- add. criteria

Stephan Received on Wed Oct 16 2002 - 08:00:27 CDT