[thelist] Access join query failing

spinhead evolt at spinhead.com
Tue Dec 18 14:50:30 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"

I've triple-checked the table and field names. strProductID is being passed
as a valid value. This query works:

"SELECT VendorProductsTlk.vendorid, VendorProductsTlk.productid,
VendorProductsTlk.productlink FROM VendorProductsTlk WHERE
VendorProductsTlk.productid = " & strProductID

What am I doing wrong with my JOIN?

Thanks.

spinhead





More information about the thelist mailing list