@Entity
public class EntityC implements Serializable {

  private static final long serialVersionUID = 1L;

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

  private String reference;

  @ManyToOne(cascade = CascadeType.REFRESH, fetch = FetchType.LAZY)
  @JoinColumn(name = "entity_e_id")
  private EntityE entityE;


}

@Entity
public class EntityE implements Serializable {

    private static final long serialVersionUID = 1L;

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

    private String name;


}

public class MyProjection implements Serializable {

  private static final long serialVersionUID = -3431863476946276142L;

  private Long entityEId;
  private Long entityCId;

  private String entityEName;
  private String entityCReference;

  public MyProjection(
      Long entityEId,
      Long entityCId,
      String entityEName,
      String entityCReference) {
    this.entityEId = entityEId;
    this.entityCId = entityCId;
    this.entityEName = entityEName;
    this.entityCReference = entityCReference;
  }
  
  public MyProjection(
      Long entityEId,
      Long entityCId) {
    this.entityEId = entityCId;
    this.entityEId = entityCId;
  }

  
  public MyProjection() {}
  
}

select new MyProjection(e.id, c.id, e.name, c.reference)
from EntityC c right join c.entityE e;

select e1_.id as col_0_0_, c0_.id as col_1_0_, e1_.name as col_2_0_, c0_.reference as col_3_0_
from entity_c c0_ 
right outer join entity_e e1_ on c0_.entity_e_id=e1_.id;

select c0_.entity_e_id as col_0_0_, c0_.id as col_1_0_, e1_.name as col_2_0_, c0_.reference as col_3_0_
from entity_c c0_ 
right join entity_e e1_ on c0_.entity_e_id=e1_.id;