Hi, I would like to know if it possible to create a query using the criteria API of deltaspike data, to represent a select statement like this one:
SELECT A.FIELDA, A.FIELDB, A.FIELDC, C.FIELDB, D.FIELDB, E.FIELDB, B.FIELDC FROM TABLE_A A INNER JOIN TABLE_B B ON A.FIELDA = B.FIELDC LEFT join TABLE_C C on C.FIELDA = A.FIELDD left join TABLE_D D on D.FIELDB = B.FIELDC left join TABLE_E E on E.FIELDB = A.FIELDE left join TABLE_F F on F.FIELDA = B.FIELDF WHERE B.FIELDG = 1 where there are joins between different tables. Looking at the documentation it seems to me that it is only possible to build a criteria based on the class the is declared as the CriteriaSupport parameter, which in my case is A. Thanks for any help Kelly
