如何根據(jù)父表id從一對(duì)多關(guān)系的兩個(gè)表中檢索數(shù)據(jù)。我必須實(shí)體貸記和借記。貸方是父實(shí)體，借方是子實(shí)體。在貸方 cid camount coping cbusiness ctotal 1 50 60 90 200 2 10 20 30 60 3 5 4 3 12 在借方 did damount ddescription 1 100 market 2 200invest 3 20 Nothing 4 500 標(biāo)記在第三個(gè)表中，我在那里存儲(chǔ)了該表的參考 ID上面兩個(gè)表使用一對(duì)多關(guān)系下面的表是自動(dòng)創(chuàng)建的credit_debit c_cid d_did 1 1 1 2 2 3 2 4 當(dāng)我將cid傳遞給JPQL查詢時(shí)如何通過(guò)id檢索數(shù)據(jù)我嘗試編寫 JPQL 查詢，但它們會(huì)顯示錯(cuò)誤。就像這個(gè)查詢 @Query(value= "select c,d from Credit as c, Debit as d where c.cid=c.cid")1.Credit.javapackage com.rajesh.model;import java.util.ArrayList;import java.util.Arrays;import java.util.Date;import java.util.List;import javax.persistence.CascadeType;import javax.persistence.Column;import javax.persistence.Entity;import javax.persistence.GeneratedValue;import javax.persistence.GenerationType;import javax.persistence.Id;import javax.persistence.JoinColumn;import javax.persistence.JoinTable;import javax.persistence.OneToMany;import javax.persistence.Table;import org.springframework.core.annotation.Order;import org.springframework.format.annotation.DateTimeFormat;@Entity@Table(name="credit")public class Credit extends BaseEntity{    @Id    @GeneratedValue(strategy=GenerationType.AUTO)    @Column    private long cid;    @Column @Order    private long openingbalance;    @Column    @DateTimeFormat(pattern = "yyyy-MM-dd")    private Date date;    @Column @Order    private long debittotal;    @Column @Order    private long drawertotal;    @Column @Order    private long debittotalplusdrawertotal;    @Column @Order    private long todaybusiness;    @OneToMany(cascade={CascadeType.ALL})    @JoinTable(name="credit_debit",                joinColumns=@JoinColumn(name="c_id"),                inverseJoinColumns=@JoinColumn(name="d_id"))    private List<Debit> debits = new ArrayList<Debit>(Arrays.asList());2.Debit.javapackage com.rajesh.model;import javax.persistence.Column;import javax.persistence.Entity;import javax.persistence.GeneratedValue;import javax.persistence.GenerationType;import javax.persistence.Id;import javax.persistence.Table;