SQL 删除操作的语法在Hql中报错_JAVA_编程开发_程序员俱乐部

delete c from Table1 c, Table2 d      --ERROR
where c.refId = d.id
and d.contract.id = '001'
and d.year=2010

delete c from table1 c, table2 d      --CORRECT
where c.refId = d.id
and d.contractId = '001'
and d.year=2010

 
delete c from Table1 c                --CORRECT
where c.refId in (select d.id from Table2 d where d.contract.id = '001' and d.year=2010)