Hi all, I have three tables:
partners (id,name,url,desc) services (id,desc,category) partner_service_rel (pid,sid) Each partner offers a range of services, and each services has an id, description, and category. Now, it's EASY to search for partners that offer a certain service, but I can't figure out a smart way to list all services for a specific partnerID, grouped by category. I got this far (which I think is perhaps WAY off track!!): SELECT services.*, partners.id FROM services, partner_service_rel WHERE partner_service_rel.pid='1' AND partners.id=partner_service_rel.sid And I'm getting "Unknown table 'partners' in field list". Any advice warmly received :) Justin French sql,query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
