在SQL Server中选择具有多个表的查询

SELECT \"article\"                  AS type
     , crossarticle_article.id    AS id
     , crossarticle_article.Title AS title_subject
FROM crossarticle_article 
WHERE Title LIKE \"%userinput%\"

UNION ALL

SELECT \"blog entry\"               AS type
     , blogs_entries.id           AS id     
     , blogs_entries.title        AS title_subject
FROM blogs_entries
WHERE title LIKE \"%userinput%\"

UNION ALL 

SELECT \"forum post\"               AS type
     , forums_posts.id            AS id
     , forums_posts.subject       AS title_subject
FROM forums_posts
WHERE subject LIKE \"%userinput%\"

UNION

UNION ALL

SELECT Title
FROM crossarticle_article
WHERE Title = \'%term%\'
UNION
SELECT Title
FROM blogs_entries
WHERE Title = \'%term%\'
UNION
SELECT subject AS Title
FROM forums_posts
WHERE Title = \'%term%\'

SELECT Title
FROM crossarticle_article
WHERE Title = @Title

UNION

SELECT title
FROM blogs_entries
WHERE title = @Title

UNION

SELECT subject
FROM forums_posts
WHERE subject = @Title