我有以下实体，

@Entity
    @Table(name = "person")
    public class Person implements Serializable {

        @Id
        @GeneratedValue(strategy = GenerationType.IDENTITY)
        @Column(name = "id")
        private Long id;

        // Other fields 
    }

     @Entity
        @Table(name = "agreement")
        public class Agreement implements Serializable {

            private static final long serialVersionUID = 15L;

            @Id
            @GeneratedValue(strategy = GenerationType.IDENTITY)
            @Column(name = "id")
            private Long id;

            @ManyToOne
            @JoinColumn(name = "person_id", nullable = false)
            private Person person;

            @ManyToOne
            @JoinColumn(name = "company_id", nullable = false)
            private Company company;

        }

    @Entity
    @Table(name = "company")
    public class Company implements Serializable {

        @Id
        @GeneratedValue(strategy = GenerationType.IDENTITY)
        @Column(name = "id")
        private Long id;

        @Column(name = "name", length = 100)
        private String name;
    }

我需要找所有和公司有协议的人，公司id是45。下面是我为获取详细信息而编写的本机查询。

SELECT distinct p.* ROM person p INNER JOIN agreement a ON a.person_id = p.id where a.company_id = 45;

但我被告知要将其转换为jpa实体查询。我想到了下面这个，

SELECT distinct p  FROM Person p INNER JOIN Agreement a WHERE a.person = p AND a.company.id = 45;

但这给了我一个例外，
原因：org.hibernate.hql.internal.ast.querysyntaxception:应为join的路径[在org.hibernate.hql.internal.ast.querysyntaxception.convert（querysyntaxception）中选择distinct p from person p inner join agreement a，其中a.person=p和a.company.id=45]。java:74)在org.hibernate.hql.internal.ast.errorcounter.throwqueryexception（errorcounter。java:91)在org.hibernate.hql.internal.ast.querytranslatorimpl.analyze（querytranslatorimpl。java:268)在org.hibernate.hql.internal.ast.querytranslatorimpl.docomFile（querytranslatorimpl。java:190)在org.hibernate.hql.internal.ast.querytranslatorimpl.compile（querytranslatorimpl。java:142)在org.hibernate.engine.query.spi.hqlqueryplan。java:115)在org.hibernate.engine.query.spi.hqlqueryplan.（hqlqueryplan。java:76)在org.hibernate.engine.query.spi.queryplanche.gethqlqueryplan（queryplanche。java:150)在org.hibernate.internal.abstractsessionimpl.gethqlqueryplan（abstractsessionimpl。java:302)在org.hibernate.internal.abstractsessionimpl.createquery（abstractsessionimpl。java:240)在org.hibernate.internal.sessionimpl.createquery（sessionimpl。java:1894)在org.hibernate.jpa.spi.abstractentitymanagerimpl.createquery（abstractentitymanagerimpl。java:305
有人能帮我找出我在询问中做错了什么吗？