title: select query with multiple tables in sql server
body: <p>hey guys,
  i have 3 tables in my sql server database.
  1. crossarticle_article has field: Title
  2. blogs_entries  has field: title
  3. forums_posts.  has field: subject</p>
  
  <p>now what i want to do is, i have a search on my website, when user enters any keyword in the searchbox and hit button, it should search for the title in all these table and should return single resultset.</p>
  
  <p>how can i achieve this, i am using sql server 2008</p>