hello,

i am using this query in my repository :

@Query(value="select pcnd.CNDCNDRFNUM from ISMCND pcnd JOIN ISMCND cnd ON pcnd.CNDRFNUM = cnd.CNDCNDRFNUM and cnd.CNDRFNUM=?1", nativeQuery=true)
Long findStateByCityId(Long CityId);


getting error while running the project .


org.hibernate.hql.ast.QuerySyntaxException: unexpected token:
fromISMCND near line 1, column 25 [select pcnd.CNDCNDRFNUM fromISMCND
pcndJOIN ISMCND cndON pcnd.CNDRFNUM = cnd.CNDCNDRFNUMand cnd.CNDRFNUM=?]


please help...

thanks,
Ghanshyam