基于子类条件的InheritanceType.JOINED连接查询

Question

使用NamedQuery，如何根据子类的字段获取使用InheritanceType.JOINED的相关表？

我有一个类似于此的设置：

带有的NamedQuery类

@NamedQuery(<named-query>)
@Entity
@Table(name="T_PERSON")
public class Person {
    private Vehicle vehicle;
}

由第一类引用的抽象类：

@Entity
@Table(name = "T_VEHICLE")
@DiscriminatorColumn(name = "vehicleType")
@Inheritance(strategy = InheritanceType.JOINED)
public abstract class Vehicle {
    private Long vehicleId;
    private String vehicleType;
}

Abstact类的混凝土子类：

@Entity
@Table(name = "T_CAR")
@DiscriminatorValue("CAR")
public class Car extends Vehicle {
    private String make;
}

我试图在<named-query>类中编写一个类似于这个SQL的Person：

SELECT * FROM T_PERSON person
LEFT JOIN T_VEHICLE vehicle ON vehicle.VEHICLE_ID = person.VEHICLE_ID
LEFT JOIN T_CAR car on car.VEHICLE_ID = vehicle.VEHICLE_ID
WHERE car.MAKE = 'Honda'

我遇到的问题是，Person类只有对超类Vehicle的引用，而不是对子类Car的引用，因此试图编写一个类似于此的NamedQuery失败了：

Select person from Person person 
left join person.Vehicle vehicle
where vehicle.make = 'Honda'

Answer 1

解决方案是这样查询：

SELECT person FROM Person person 
INNER JOIN person.vehicle vehicle, Car car
WHERE vehicle.vehicleId = car.vehicleId
    AND car.make = 'Honda'