title: Compare two xml sql query DB2
body: <p>I have two tables in the database. Both have ID, name1. Name1 is an XML data type.
  Does anyone know of any possibility to compare the contents of these two xml?</p>
  <p><code> select * from table1 t join table2 b on t.ID = b.ID where t.name1 &lt;&gt; b.name1</code></p>
  <p>But it doesn't work. I get</p>
  <p><code>SQL Error [42818]: The data types of the operands for the operation &quot;&lt;&gt;&quot; are not compatible or comparable.. SQLCODE=-401, SQLSTATE=42818, DRIVER=4.21.29</code></p>