title: Combine two tables that have no common fields
body: <p>I want to learn how to combine two db tables which have no fields in common. I've checked UNION but MSDN says :</p>
  <blockquote>
  <p>The following are basic rules for combining the result sets of two queries by using UNION:</p>
  <ol>
  <li>The number and the order of the columns must be the same in all queries.</li>
  <li>The data types must be compatible.</li>
  </ol>
  </blockquote>
  <p>But I have no fields in common at all. All I want is to combine them in one table like a view.</p>
  <p>So what should I do?</p>