title: Set column value of a view based on which table I'm selecting from
body: <p>I'm creating a view from 2 tables. I need to create a brand new column in the view; this column must be set to 0 when I'm selecting from the first table, 1 from the second one:</p>
  
  <pre><code>Table A:
  +---------+---------+
  |column A |column B |
  +---------+---------+
  |  Boston |   USA   |
  +---------+---------+
  | Chicago |   USA   |
  +---------+---------+
  |Las Vegas|   USA   |
  +---------+---------+
  
  Table B:
  +---------+---------+
  |column A |column B |
  +---------+---------+
  |  Paris  |  Europe |
  +---------+---------+
  |  Madrid |  Europe |
  +---------+---------+
  |  London |  Europe |
  +---------+---------+
  
  Resulting View:
  +---------+---------+---------+
  |column A |column B | column C|
  +---------+---------+---------+
  |  Boston |   USA   |    0    |
  +---------+---------+---------+
  | Chicago |   USA   |    0    |
  +---------+---------+---------+
  |Las Vegas|   USA   |    0    |
  +---------+---------+---------+
  |  Paris  |  Europe |    1    |
  +---------+---------+---------+
  |  Madrid |  Europe |    1    |
  +---------+---------+---------+
  |  London |  Europe |    1    |
  +---------+---------+---------+
  </code></pre>