Thanks. That was it. I'm glad it was something so simple. Just needed a
careful set of eyes. I was worried my understanding of SQL/JOINs was
screwy.
Thanks again.
Nick
PS I'll read up on the FULLTEXT matching. I don't know it well.
>> $query = "SELECT v.vbusiness, v.vcategory, v.vurl, v.vcity, v.vstate,
>> v.vendorid ";
>> $query .= "FROM vendorproducts AS vp ";
>> $query .= "INNER JOIN vendors AS v ON vp.vpvendorid = v.vendorid ";
>> $query .= "INNER JOIN products AS p ON vp.vpvendorid = p.productid ";
^^^^^^^^^^
>I'd guess the problem is right there. Shouldn't that be something like
> INNER JOIN products AS p ON vp.vpproductid = p.productid
>instead?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
