title: grails gorm executeQuery HQL inner join
body: <p>I am trying to do a simple inner join using GORM's executeQuery but getting a QuerySyntaxException.....I believe my hql is ok. Here is my query</p>
  
  <pre><code>def query = Institution.executeQuery("select longName from Institution inner join TacticalIndustryCode.idInstitution")
  log.info(query.size())
  </code></pre>
  
  <p>I tried this with same error too:</p>
  
  <pre><code>def query = Institution.executeQuery("from Institution inner join TacticalIndustryCode.id")
  </code></pre>
  
  <p>Here is my exception that I am receiving</p>
  
  <pre><code>org.hibernate.hql.ast.QuerySyntaxException: Invalid path: 'null.idInstitution' [select longName from erebus.industryGroup.Institution inner join TacticalIndustryCode.idInstitution]
      at erebus.industryGroup.TacticalIndustryCodeController$$ENunaZiV.list(TacticalIndustryCodeController.groovy:20)
      at grails.plugin.cache.web.filter.PageFragmentCachingFilter.doFilter(PageFragmentCachingFilter.java:195)
      at grails.plugin.cache.web.filter.AbstractFilter.doFilter(AbstractFilter.java:63)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
      at java.lang.Thread.run(Thread.java:722)
  </code></pre>