[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