relational tables query help

2003-01-20 Thread Justin French
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

Re: relational tables query help

2003-01-20 Thread Natale Babbo
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