SQL Server: Full-Text Searching Across Multiple Tables
Sometimes a full-text search needs to be performed on multiple tables. For example, if we have two tables, Post and Comment, we may want to search for posts that have keywords both in the post text and in the comments. SQL Server doesn’t allow to include multiple tables in the CONTAINS and FREETEXT predicates. We [...]