SQL Navigator currently does not provide context sensitive help when ANSI JOIN syntax is used. For example:
Context sensitive help is triggered when entering this SQL in the SQL editor
select c.cmn_clnt_sk
from cmn_clnt c,
cmn_clnt_indv i
where c.cmn_clnt_sk = i.cmn_clnt_indv_sk
and c.cmn_clnt_cd_sk = 5
but not when the query is restructured using ANSI JOIN
select c.cmn_clnt_sk
from cmn_clnt c
join cmn_clnt_indv i on c.cmn_clnt_sk = i.cmn_clnt_indv_sk
and c.cmn-clnt_cd_sk = 5
Please enhance SQL Nav so it provides context-sensitive help for ANSI JOIN syntax (JOIN, RIGHT JOIN, LEFT JOIN). i.e. automatic dot lookup to support ANSI JOIN syntax