[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