Hello ,
i have tow business object , the parent called : CreationBC
and the second is : ProduitCreationBC
the parent business object (CreationBC ) has this attributes :
reference -> string
products -> ProduitCreationBC (multiple)
in H2 browser i use this sql to retrieve data from the table ProduitCreationBC and retrieve form each record the attribute of it parent
SELECT PRODUITCREATIONBC.*, CREATIONBC.reference FROM PRODUITCREATIONBC JOIN CREATIONBC ON PRODUITCREATIONBC.creationbc_pid = CREATIONBC.persistenceid;
i get a list of product and each records contain the attribute "reference" of his parent table from "CreationBC"
how can i convert this sql to jpql custom query , i did this but it didn't work , any help please
SELECT p, c.reference FROM ProduitCreationBC p JOIN p.creationBC c