[thelist] Access join query failing

[spinhead]

Actually, the browser made inappropriate advances, and I had to slap its
face.



Okay, I'm a little foggy today and perhaps my question wasn't as complete as
it might have been. Here's the error message:

Microsoft JET Database Engine error '80040e14'

Syntax error in FROM clause.

/buy2.asp, line 46

Line 46 being where I pass the query to the db. There is valid data for the
query (I pass the productid, ask for vendorid from VendorsProductsTlk, and
match it with vendorid from Vendors, then get the matching vendorname.) No
missing names, bad vendorids, it all looks good. Breaks no matter what
productid I pass it, whether there's only one matching line from the db or
several.

So, if the query looks correct and the data looks correct, is there a next
step?

Thanks.

joel



----- Original Message -----
From: "rudy" <r937 at interlog.com>
To: <thelist at lists.evolt.org>
Sent: Tuesday, December 18, 2001 1:04 PM
Subject: Re: [thelist] Access join query failing


> > What am I doing wrong with my JOIN?
>
> nothing
>
>
>
> oh, you wanted more?  like, maybe a guess as to what's wrong?
>
> i'll need more info about what "failing" means   ;o)
>
> your pc crashes?  goes into an infinite loop?  installs ie6?
> the query returns no rows?  returns all rows?  returns wrong rows?
>
> after checking your syntax, the next step is checking your data
>
> are the join fields the same data type?
>
> *are* there actually any matching keys?
>
>
> rudy
>
>
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt !
>