SELECT cast(g1csf.pacid /10000000 as int) as UREG, g1csf.* into ProgeddTests FROM g1csf INNER JOIN g1_cnsin ON G1csf.cnsinv = G1_cnsin.cnsinv where substring(ltrim(str(g1csf.pacid,14)),8,2) ='20' and substring(ltrim(str(g1csf.pacid,14)),1,2) ='26'
any idea why a Having Clause cannot find the UREG column that is in position 1 of the table in a having clause?
The last line of my SQL should read something like: Having UREG >= 26000