title: Compare Two Tables on Snowflake Where it Contains NULL Values
body: <p>Hello everyone i am facing an issue, i.e
  Table T1 with schema</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">ID</th>
  <th style="text-align: left;">TYPE</th>
  <th style="text-align: left;">MODEL_ID</th>
  <th style="text-align: left;">FREQ</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">1</td>
  <td style="text-align: left;">Car</td>
  <td style="text-align: left;">234</td>
  <td style="text-align: left;">5</td>
  </tr>
  <tr>
  <td style="text-align: left;">2</td>
  <td style="text-align: left;">SUV</td>
  <td style="text-align: left;">12</td>
  <td style="text-align: left;">6</td>
  </tr>
  <tr>
  <td style="text-align: left;">3</td>
  <td style="text-align: left;">EV</td>
  <td style="text-align: left;">NULL</td>
  <td style="text-align: left;">NULL</td>
  </tr>
  <tr>
  <td style="text-align: left;">4</td>
  <td style="text-align: left;">HV</td>
  <td style="text-align: left;">NULL</td>
  <td style="text-align: left;">NULL</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>TABLE T2 with schema and data</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">ID</th>
  <th style="text-align: left;">TYPE</th>
  <th style="text-align: left;">MODEL_ID</th>
  <th style="text-align: left;">FREQ</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">3</td>
  <td style="text-align: left;">EV</td>
  <td style="text-align: left;">NULL</td>
  <td style="text-align: left;">NULL</td>
  </tr>
  <tr>
  <td style="text-align: left;">4</td>
  <td style="text-align: left;">HV</td>
  <td style="text-align: left;">NULL</td>
  <td style="text-align: left;">NULL</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Now i am checking the working with the following query,</p>
  <pre><code>SELECT *  FROM T1 AS T, T2 AS N
    WHERE T.ID = N.ID AND T.TYPE = N.TYPE AND T.MODEL_ID = N.MODEL_ID AND T.FREQ = N.FREQ
  </code></pre>
  <p>The result is empty set, i knew that i need to implement a null safe query but to this scenario how do i achieve it.</p>
  <p><strong>Note: Here ID is not an identifier, so should compare with every column in the table.</strong></p>