Click here to Skip to main content
14,640,670 members
Rate this:
Please Sign up or sign in to vote.
See more:
I have this:
@OneToMany(cascade = CascadeType.ALL, mappedBy = "cliente")
    private List<order> order = new ArrayList();
    private Customer customer;
    private Order order

Is it possible to get a querry that appear if a customer bought a book?

What I have tried:

I tried to do:

SELECT l.order FROM soldBook l INNER JOIN l.order p  INNER JOIN p.customer c WHERE l.customer = :” +customer
MadMyche 14-Jan-19 16:53pm
Please provide the schema for that tables used to populate those objects

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100