MySQL Forums
Forum List  »  General

Re: Multi-Table Query Problems
Posted by: nick
Date: March 14, 2005 09:02AM

Woops, that should have read:

SELECT v.vbusiness, v.vcategory, v.vurl, v.vcity, v.vstate, v.vendorid
FROM vendorproducts AS vp
INNER JOIN vendors AS v ON vp.vpvendorid = v.vendorid
INNER JOIN products AS p ON vp.vpvendorid = p.productid
WHERE (p.productname LIKE '%Apples%')
OR (p.productfamily LIKE '%Apples%')
OR (v.vcategory LIKE '%Apples%')
GROUP BY v.vbusiness

Options: ReplyQuote


Subject
Written By
Posted
March 14, 2005 08:58AM
Re: Multi-Table Query Problems
March 14, 2005 09:02AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.