I would like to know how to make a custom query, to obtain records of several tables. I have read and tested with the JPQL documentation that the studio provides as a reference, I have used JOIN, but I have not managed to make it work and it generates an error when I finish. Has anyone made a query like this?
I have used some queries previously but it is really limited not being able to obtain data from several tables through a single query as we do a normal database like sql.
I would greatly appreciate your help.