Hi,
I have written a query which have joins from multiple table when I runs the query on SQL it runs but when I try to run with the createQuery option provided by Hibernate it gives error . Below is my query

SELECT custs.xwg4tx, custs.xwb3cd, custs.xwhitx, custs.xwe0nb, custs.xwjun0, custs.xwdvcd, cusgrp.xwkhtx, slmen.pname, dists.dname, custs.xwgiva, custs.xwbtcd, custs.xwaocd, custs.xwbbcd, custs.xwg4t0, custs.xwc7st, custs.xwdast, custs.xwbpd0, custs.xwbad0, custs.xwf0va, custs.xwasdt, custs.xwf0v0, custs.xwbqdt, custs.xwf1va, custs.xwf1v0, custs.xwf2va, custs.xwf3va, custs.xwf4va, custs.xwf6va, custs.xwidv0, custs.xwgava, custs.xwgbva, custs.xwgcva, custs.xwgdva, custs.xwgeva, custs.xwgfva, custs.xwggva, custs.cusno, custs.xwbccd, custs.xwbncd, custs.person, custs.dsdcde, custs.xwb2cd FROM com.databorough.hbmbean.Custs AS custs LEFT OUTER JOIN Cusgrp AS cusgrp ON custs.xwbncd=cusgrp.xwbncd LEFT OUTER JOIN Slmen AS slmen ON custs.person=slmen.person LEFT OUTER JOIN Dists AS dists ON custs.dsdcde=dists.dsdcde WHERE xwbccd = 'ACC1'

Error is :

unexpected token: ON near line 1, column 670

Thanks

try "with" instead:

I am not understand well can u explain it or modify my query

simply use the keyword "with" instead of "on". otherwhise you could use subquerries.