title: Make this seats busy
body: <p>I have 2 tables in my <code>DATABASE</code>. First table is table of <code>seats</code> that consists of <code>row</code>, <code>seat</code> and <code>availability</code>. Second table is table of <code>tickets</code> that consists of <code>purchased seats</code>.</p>
  <pre><code> - CREATE TABLE Seats(
  Seat INT,
  Row INT,
  Availability BIT)
   - INSERT INTO Seats VALUES (1,1,1), (2,1,1), (1,2,1), (2,2,1)
   - CREATE TABLE Purchased(
  Seat INT,
  Row INT)
  - INSERT INTO Purchased VALUES (1,1), (2,2)
  </code></pre>
  <p>I want to change <code>availability</code> to <code>0</code> for <code>seat</code> that are in <code>Purchased</code> table without repeating <code>UPDATE ... SET...WHERE</code> several times.</p>
  <p>The result need to be
  <code>- SEATS = (1,1,0), (2,1,1), (1,2,1), (2,2,0)</code></p>