G&L version 7.1.1.p1 an p2
I was supplied a complex sql query to gather information from a SQL database.
In order to get the information it requires two select (in-line?) statements.
Select a.email, a.user, a.group from user_account UA
(SELECT a.user_account_key, MIN(b.entry_time) FIRST_LOGON, MAX(b.entry_time) LAST_LOGON, COUNT(*) NUM_LOGONS ......
FROM user_account A)
When I run the test it responds with This statement type is not supported
There are a lot of inner joins as well, but the issue seems to only occur when the second query is added.
The full query works from in SQL Developer.