title: Sum Of Two Queries HQL
body: <p>I have two tables, Ticket and Job, and both have a ClientId field and a TimeSpent field.</p>
  
  <p>I'm using HQL and can get the sum of TimeSpent from one table but I don't know how to get it from multiple tables as HQL has no <code>UNION</code>.</p>
  
  <p>This is what I'm using at the moment:</p>
  
  <pre><code>SELECT SUM(j.TimeSpent) FROM Job j WHERE j.ClientId = :clientId
  </code></pre>