Hi,

I wanted to update a table data based on multiple joins with different table keys in where condition. My query is as follows.

Update table1 t1, table t2, table t3 set t1.col1=?, t1.col2=? where t1.col1=t2.col3 and t2.col3=t3.col4

I wanted to write the above query using Hibernate query language and update the table1 data based on the joins with t2 and t3 tables.

Please let me know how to perform this operation.

Thanks

Hibernate doesn't support this kind of queries. See http://docs.jboss.org/hibernate/stable/ ... tch-direct