I know this isn't really an asp.net question, but I couldn't find a proper place for this question (SQL Server questions). I figured I'd find the most seasoned MS developers here--I hope you can help.
I am using a SQL Full Text Catalog for a simple search of multiple tables on my website. I wrote a simple stored procedure that searches each table for the search text using contains(*, @searchText).
I am trying to modify one of the queries but cannot figure out the correct syntax:
Basically, I want to search the chapters table, but only to return the result when the chapter (Chapter.caseId FK -> Casestudies.Id PK) belongs to a published case study. Can anyone point me in the right direction?
SELECT c.ID, TABLENAME = 'CHAPTERS' from Chapters LEFT OUTER JOIN CASESTUDIES cs on cs.Id = c.caseId where cs.isPublished = 1 AND where contains(*, @searchText)
Thanks in advance! Please let me know if you need any clarification.