如何根據父表id從一對多關系的兩個表中檢索數據。我必須實體貸記和借記。貸方是父實體，借方是子實體。在貸方 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 標記在第三個表中，我在那里存儲了該表的參考 ID上面兩個表使用一對多關系下面的表是自動創建的credit_debit c_cid d_did 1 1 1 2 2 3 2 4 當我將cid傳遞給JPQL查詢時如何通過id檢索數據我嘗試編寫 JPQL 查詢，但它們會顯示錯誤。就像這個查詢 @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;