JPAJoinTable1.java

List<AppInfo> appInfos = appInfoRepository.findByByTxnDate(LocalDate.parse("20200116", DateTimeFormatter.ofPattern("yyyyMMdd")));
Query query = this.entityManager.createNativeQuery("SELECT app.appId, app.caseId, [case].keyIndex FROM [esolution].[dbo].[AppInfo] app JOIN CaseInfo [case] ON app.caseId = [case].caseId WHERE app.txnDate >= Convert(datetime, ?1);");
query.setParameter(1, "2020-01-16");

Object obj = query.getResultList();
if (obj != null)
    System.out.println((List<DataLakeAppInfo>) obj);