title: Full Join in Hibernate HQL
body: <p>I am trying to use FULL JOIN on particular columns of two tables using HQL</p>
  
  <pre><code>List&lt;B&gt; expiredMacs = getHibernateTemplate()
                  .find("from B b join A a where b.type != 'USER' and (b.id != a.id or (b.name == a.name and b.value != a.value))");
  </code></pre>
  
  <p>But it's throwing error unexpected token: = near line 1, column 325</p>
  
  <p>Any idea what's going wrong?</p>
  
  <p>in SQL </p>
  
  <pre><code>SELECT B.* FROM  B b, A a WHERE b.type != 'USER' AND (b.id != a.id or (b.name == a.name and b.value != a.value))
  </code></pre>