1
回答
hql多表联合查询报错

有三张表,TbStorageDatePath、TbStorageDevPath、TbStorageFilePath,有主外键关系,现通过HibernateDaoSupport类find方法进行查询,hql语句:

select f.storageFileId,f.storageFileName,f.storageDateId,da.storageDatePath, f.storageDevId, dev.storageDevIdPath,f.storageFileTime, f.storageFilePath
from TbStorageFilePath f,TbStorageDevPath d,TbStorageDatePath da where f.storageDateId=da.storageDateId and f.storageDevId=dev.storageDevId and d.storageDevIdPath in('52011426001310011646','52011426001310012104')

求各位大神指点迷津,到底是哪里错了,先谢谢了!(小弟菜鸟一个)

<无标签>
举报
顶部