we are using oracle 12c, windows os.
I have a table join that runs fine and get results in SQL developer.
But there is an redline indicating some syntax warning under the word terms.
It says
Terms is disconnected from rest of join graph
terms
enr
I understand the join does not have a ID from each table to match at the on clause, but I just use some date range checking and filters in the On statement. Is it valid? the results look fine.
SELECT enr.*
FROM ps_enrollment enr
INNER JOIN terms
ON isyearrec =1
AND terms.schoolid=0
AND enr.entrydate BETWEEN terms.firstday AND terms.lastday
AND enr.grade_level BETWEEN 9 AND 12;