[thelist] Access join query failing

John Olival johnolival at yahoo.co.uk
Tue Dec 18 16:48:37 CST 2001


>Can anyone see what's wrong with this?
>
>"SELECT VendorProductsTlk.vendorid, VendorProductsTlk.productid,
>VendorProductsTlk.productlink, Vendors.vendorname FROM VendorProductsTlk
>JOIN Vendors ON VendorProductsTlk.vendorid = Vendors.vendorid WHERE
>VendorProductsTlk.productid = " & strProductID & " ORDER BY
>Vendors.vendorname"

> Microsoft JET Database Engine error '80040e14'
>
> Syntax error in FROM clause.
>

I have had this before in Access. If you change 'JOIN' to 'INNER JOIN' then
it should work (that's if you do actually want to do an inner join, which is
the default in MS SQL, I think).

HTH

JohnO


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com





More information about the thelist mailing list