Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  what is wrong with this query

Author  Topic  ajay Starting Member 34 Posts Posted - 2001-10-03 : 10:04:44 select a.co_name,a.co_address1,a.co_address2,a.co_address3 from fri_vendor_details a,fri_vendor_offerrings b where a.vendor_code=b.vendor_code and b.service_code=1002 and a.co_city like 'Coimbatore%' or a.co_near_city like 'Chennai%' wnat to fetch records where vendor code is common and if both the co_city and co_near_city is selected. table struct is fri_vendor_offerrings vendor_code FK service_code FK fri_vendor_details vendor_code,co_name,address1,2,3,city and co_near_city Thanks ajay