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 >

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 fig