Hello,

I need help to do an update with HQL. I have 2 tables:

Table1
id
name
hash
syncflag

Table2
id
hash

I want to set the syncflag if the hash from Table1 is equals the hash from Table1.

In MySQL Query Browser this statement go:

Update Table1, Table2 set Tabel1.syncflag=1 where Table2.hash=Table1.hash;

How I have to write the HQL Statement do get the right effect? Or if isn`t it possible with HQL language, how I can solv the problem?

I have no relations in the Table1 or Table2 mapping files.

Thanks for help.

Daniel