Click here to Skip to main content
14,040,432 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)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Cookies | Terms of Service
Web05 | 2.8.190425.1 | Last Updated 14 Jan 2019
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid

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