title: BQ query, not exists/joins
body: <p>in a BigQuery I have a table.</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>VM</th>
  <th>Package</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>VM1</td>
  <td>A</td>
  </tr>
  <tr>
  <td>VM2</td>
  <td>B</td>
  </tr>
  <tr>
  <td>VM3</td>
  <td>A</td>
  </tr>
  <tr>
  <td>VM4</td>
  <td>B</td>
  </tr>
  <tr>
  <td>VM1</td>
  <td>B</td>
  </tr>
  <tr>
  <td>VM2</td>
  <td>C</td>
  </tr>
  <tr>
  <td>VM3</td>
  <td>B</td>
  </tr>
  <tr>
  <td>VM4</td>
  <td>C</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>How can I get results, so all distinct VMs would be listed, but having <code>Package</code> column with value <code>null</code> (or empty, or <code>Yes</code> and <code>No</code>) if particular package not exists. I.e. I need to be listed all VMs (without duplicating), which have the package <code>A</code> installed, and the rest with value let say <code>null</code>:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>VM</th>
  <th>Package</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>VM1</td>
  <td>A</td>
  </tr>
  <tr>
  <td>VM2</td>
  <td>null</td>
  </tr>
  <tr>
  <td>VM3</td>
  <td>A</td>
  </tr>
  <tr>
  <td>VM4</td>
  <td>null</td>
  </tr>
  </tbody>
  </table>
  </div>