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