Oracle Error Message
PLS-00209: table ‘string’ is not in FROM clause
Reason for the Error
In a query, a table referenced by the select list is not named in the FROM clause.
Solution
Check the spelling of the table names, make sure each column in the select list refers to a table in the FROM clause, then re-execute the query.