Minor Description
The following valid ISO-SQL constructs will not parse
Unsupported SubQuery Expression 'c1': Correlating expression cannot contain unqualified column references
The statement will parse if the predicate is changed to where tjoin1.c1 in ( ....)
select tjoin1.rnum, tjoin1.c1, tjoin1.c2 from tjoin1 where c1 in ( select c1 from tjoin1)
select tjoin1.rnum, tjoin1.c1, tjoin1.c2 from tjoin1 where c1 in ( select tjoin1.c1 from tjoin1)
select tjoin1.rnum, tjoin1.c1, tjoin1.c2 from tjoin1 where c1 in ( select x.c1 from tjoin1 x)
Attachments
Attachments
Issue Links
- links to
