HQL: from CatalogItem as item where item.author.name like 'Лев Толстой' SQL: select * from CATALOG_ITEM i inner join AUTHOR a on (i.AUTHOR_ID=a.AUTHOR_ID) where a.NAME like 'Лев Толстой'