Is this a bug or am I missing something?

query: SELECT a.* into inst2 from inst1 a, iuniqkey b where upper(a.claimkey)=upper(b.claimkey) and a.claim_number=b.lowclaim
ERROR: No such attribute or function 'claimkey'
AbortCurrentTransaction

Seems logical to me but no such luck.

-km