title: Using a join in a Hibernate HQL update query
body: <p>i have the following hibernate mapping:</p>
  
  <pre><code> &lt;class name="Domain.Roomreservation, Core" table="Reservationroom"&gt;
      &lt;id name="ID" unsaved-value="undefined"&gt;
          &lt;generator class="native"&gt;
              &lt;!--&lt;param name="sequence"&gt;GLOBALSEQUENCE&lt;/param&gt;--&gt;
          &lt;/generator&gt;
      &lt;/id&gt;
  
      &lt;property name="FromTime" not-null="true" index="IDX_RESRAUM_FromTime" /&gt;
      &lt;property name="UntilTime" not-null="true" index="IDX_RESRAUM_UntilTime"/&gt;
  
      &lt;many-to-one name="Booking" column="Book_ID" index="IDX_RAUMRES_BOOK" lazy="false"
          class="Domain.Booking, Core" not-null="true" /&gt;
      &lt;/class&gt;
  </code></pre>
  
  <p>And the <code>Reservationroom</code> table looks like:</p>
  
  <pre><code>ID         &lt;pk&gt;
  Book_ID    &lt;fk&gt;
  FromTime
  UntilTime
  ....
  ....
  </code></pre>
  
  <p>My Hibernate Query looks like:</p>
  
  <pre><code>String hql = "UPDATE Roomreservation as rr set rr.FromTime= 12:15" +
                       "Inner Join Booking b ON rr.Book_ID= b.ID " +
                       "Where b.ID = 95637";
                          IQuery query = CurrentSession.CreateQuery(hql);
                          int result = query.ExecuteUpdate();
                          Debug.WriteLine("Rows affected: " + result);
  </code></pre>
  
  <p>But I always getting <code>Error: NHibernate.Hql.Ast.ANTLR.QuerySyntaxException</code></p>
  
  <p>Can someone help me how to get this to work?</p>