[thelist] SQL: looking for resources, have one question

[Chris Blessing]

LOL, yes, Chris is a very underutilized name. :)

I imagine Access bawked at the INNER JOIN syntax for one reason or another.
What error did you get?  I'm not even positive it's directly supported
within Access... (damn Access).

Chris Blessing
webguy at mail.rit.edu
http://www.330i.net

> > SELECT a.manufacturerID, a.ID
> >   FROM products a, manufacturers b
> >     WHERE a.manufacturerID = b.id
> >   ORDER BY a.manufacturerID
>
> this one worked.
>
> > The
> > current SQL-92
> > standard for inner joins (preferrably) is used in the FROM
> > clause as such:
> >
> > SELECT a.manufacturerID, a.ID
> >   FROM products a
> >     INNER JOIN manufacturers b
> >     ON a.manufacturerID = b.id
> >   ORDER BY a.manufacturerID
>
> this one didn't. which is probably what is expected.
>
>
> thanks for your help chris.
>
>
> chris.
>
> p.s. hey look, we have the same name!! hahaha! isn't that SOOOOO wierd?