Re: Problem in a particular Query

2001-02-20 Thread Rolf Hopkins
Message - From: "anirban roy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 21, 2001 10:43 Subject: Problem in a particular Query > we have two tables > 1. servicecntr_nm > comp_cod int(11) > service_nm varchar(70) > city_cod va

Problem in a particular Query

2001-02-20 Thread anirban roy
we have two tables 1. servicecntr_nm comp_cod int(11) service_nm varchar(70) city_cod varchar(13) addr varchar(100) pin int(11) contact varchar(70) serv_cod varchar(30) 2.service_prod_index serv_cod varchar(30) prod_no varchar(20) now our aim is to find out all the service_nm that have