I would like to know if someone can please help me with the following sql statements..
Im trying to join these 2 Containstables sq lstatements together...but I dont know how..they both Containstables...and have no relation to each other....but I need to search both tables.
How do I join these two statements?
Select CompanyName, EmailAddress, Tel_nr1, Tel_nr2, PhysicalAddress, CityName,WebsiteAddress from SalesRep_CompanyNomination as P INNER JOIN CONTAINSTABLE(SalesRep_CompanyNomination, (CompanyName),@CompanyName_searchwords) AS KEY_TBL ON p.JobID = KEY_TBL.[KEY] where (P.EmailAddress = @EmailAddress or P.Tel_nr1 = @Telnr1 or P.Tel_nr2 = @Telnr1 or P.Tel_nr1 = @Telnr2 or P.Tel_nr2 = @Telnr2 ) ORDER BY RANK DESC
Select P.CompanyName , P.EmailAddress, C.City from CompanyDetails as P inner join DDLFilterCity C on C.CityID = P.CityID INNER JOIN CONTAINSTABLE(CompanyDetails, (CompanyName),@CompanyName_searchwords) AS KEY_TBL ON p.CompanyID = KEY_TBL.[KEY] where (P.EmailAddress = @EmailAddress or P.PhoneNumber = @Telnr1 or P.PhoneNumber = @Telnr2 ) ORDER BY RANK DESC
Thank you so so much for having a look at this
I seriously seriously appreciate this
View Complete Post