Hibernate Join Query - Should be easy
I am pretty new at using hibernate and need some help.
I want to perform the bellow query in hibernate but can't seem to get the syntax correct. I am using a Postgres database.
This query works when I run directly on the database:
I have attached my hibernate config
SELECT x, y
FROM submissions AS s
JOIN submissions_new AS sn ON (s.id = sn.submission_id)
JOIN submissions_edited_voyages AS ev ON (sn.editor_edited_voyage_id = ev.id)
JOIN voyages AS v ON (ev.voyage_iid = v.iid)
WHERE s.id = 1793231;
Thanks for the help!!!