Hello,
As a way of intro, I am a power end-user that uses the SQL Developer to pull specific data using simple SQL statements (SELECT only). As I start to pull more data, I need to join various tables. I have been doing this by 'INNER JOIN' statements which works fine for a couple of tables, but I'd really like to use the Query Builder in order to build relationships by drag/drop. However, every time I attempt to use the query builder I get the following error:
Text is not a valid, single SELECT statement.
Syntax Error at line 264, column 36
FROM PO.PO_EMPLOYEE_HIERARCHIES_ALL
^^^
Expected: ';','WHERE',identifier,
Query Builder disabled.
Any idea on what is causing this error and how I can fix it? Many thanks in advance!
FYI - I am using version 4.0.1.14