title: please help to write the query to fetch specific column by joining multiple table in jpa
body: <pre><code>@Query(&quot;select new com.example.hallticket.model.AspirantDetailModel(
  ah.applicantName,
  ah.applicantEmailId,
  ah.applicantHallticketNumber,
  ac.applicantCredId,
  casbG.shortName,
  ecitym.cityName,
  es.examDate,
  es.examSlotName,
  cm.centerCode,
  cm.centerName,
  cm.centerAddress)
  from ApplicantHallticket ah
  join ah.applicantCredential ac
  join ah.examSlotwiseReportingtime eswrt
  join ah.applicantCenterAllotment aca
  join eswrt.casbGroup cg
  join eswrt.examSlot es
  join aca.examCenterMapping ecm
  join ecm.centreExamslotMapping cesm
  join ecm.regionCentreMapping rcm
  join rcm.examCityMaster ecitym
  join rcm.centerMaster cm
  where ah.applicantHallticketNumber=?1&quot;) 
  public AspirantDetailModel getAspirantDetails(String hallticketNo);
  </code></pre>