title: creating a view without join in SQL
body: <p>I have two tables:</p>
  <p><strong>Customers</strong><br />
  <code>customer_id</code>,<br />
  <code>name</code></p>
  <p><strong>Orders</strong><br />
  <code>customer_id</code>,<br />
  <code>date</code>,<br />
  <code>amount</code></p>
  <p>I want to create a view with: <code>customer_id</code>, <code>name</code>, <code>is_active</code> - a boolean field that holds the value <code>true</code> when the customer has at least one record in the <strong>Orders</strong> table for the current year.</p>
  <p>Can I do it without using the <code>join</code> operator?</p>