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

[Chris W. Parker]

> -----Original Message-----
> From: Chris Blessing [mailto:webguy at mail.rit.edu]
>
> 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).

actually... hehe... i tried it again, and, well look at that, it worked.
i blame it on user error.

> > > 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.