tag:blogger.com,1999:blog-1485444829142360940.post6500150000427302598..comments2022-11-03T02:36:59.460-07:00Comments on CSharpCollections: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, , >= or when the subquery is used as an expression.Velmaheshkhttp://www.blogger.com/profile/09818608823066467806noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-1485444829142360940.post-55516578305184040932010-10-19T00:38:44.398-07:002010-10-19T00:38:44.398-07:00finally i solved the problem...based on below..
...finally i solved the problem...based on below..<br /><br /><br />SELECT ReferringPhysician.LastName ,ReferringPhysician.FirstName,RefPhysLocations.LocationName<br /> FROM ReferringPhysician LEFT JOIN RefPhysLocations<br /> ON ReferringPhysician.ReferringPhysicianID = RefPhysLocations.ReferringPhysicianID<br /> WHERE LocationName LIKE '%'+@keyword+'%'Velmaheshkhttps://www.blogger.com/profile/09818608823066467806noreply@blogger.com