because there isn't any partners table in the FROM clause! --- Justin French <[EMAIL PROTECTED]> ha scritto: > 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 >
______________________________________________________________________ Yahoo! Cellulari: loghi, suonerie, picture message per il tuo telefonino http://it.yahoo.com/mail_it/foot/?http://it.mobile.yahoo.com/index2002.html --------------------------------------------------------------------- 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