title: variable needs to work on join level
body: <p>I am getting an error with this, that 'column or global variable grc# not found' what is not correct here?</p>
  
  <pre><code>    SELECT "OEINH2"."IHDOCD", "OEINH2"."IHINV#", "ADRES1"."ADINTA", "ADRES1"."ADENT#", "ADRES1"."ADSFX#", adres1.adent#  concat  adres1.adsfx# as "grc#"
       FROM   
  "ASTDTA"."OEINH2" "OEINH2" INNER JOIN "ASTDTA"."ADRES1" "ADRES1" ON "OEINH2"."IHGRC#"= "grc#"
       WHERE  ("OEINH2"."IHDOCD"&gt;=20160722 AND "OEINH2"."IHDOCD"&lt;=201600801)
  </code></pre>