[thelist] Access join query failing

Anthony Baratta Anthony at Baratta.com
Tue Dec 18 15:00:22 CST 2001


At 12:48 PM 12/18/2001, you wrote:
>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"

What error message area you getting??
---
Anthony Baratta
President
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."





More information about the thelist mailing list