使用JPQL JpaRepository从两个表父表Id一对多关系中检索数据

Question

如何根据父表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;