After the third table join , SQL Navigator does not show the columns on a table after typing the alias.
To reproduce the issue follow the steps below:
1. Create the following tables
create table table1 (
col1 number);
create table table2 (
col2 number);
create table table3 (
col3 number);
2.Type the query below:
SELECT *
FROM table1 a
JOIN table2 b ON a.col1 = b.col2
JOIN table3 c ON b.col2 = c.
after c. the drop down does not show the columns in table c
Same happens if writing the select like
SELECT *
FROM table1 a,
table2 b,
table3 c
where a.col1 = b.col2
and b.col2 = c.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center