Claus Pedersen
Member³
I have the following query on Scott/Tiger:
I mark it and activate query builder.
The three tables are shown, but only the relation between emp and dept is shown. If I remove the last line (with HAVING), it works OK (all three tables are related).
Maybe it has something to do with the error you get when you include a GROUP BY in the statement. Then an error message is issued: Query Builder does currently not support group by statements. If this is the case, this error message should also be issued when a HAVING clause is present in the SQL, or even better: make Query Builder work with all valid SQL :grin:
I am using version 8.0.4.1514
BTW, a little trivia: the Scott demo schema is named after Bruce Scott, one of the early Oracle developers, who created the scott/tiger demo schema for version 3 of the database. The password Tiger was the name of his cat.
SQL:
SELECT '?'
FROM emp,
bonus,
dept
WHERE dept.deptno = emp.deptno
AND bonus.ename = emp.ename
HAVING SUM (emp.comm) > 0I mark it and activate query builder.
The three tables are shown, but only the relation between emp and dept is shown. If I remove the last line (with HAVING), it works OK (all three tables are related).
Maybe it has something to do with the error you get when you include a GROUP BY in the statement. Then an error message is issued: Query Builder does currently not support group by statements. If this is the case, this error message should also be issued when a HAVING clause is present in the SQL, or even better: make Query Builder work with all valid SQL :grin:
I am using version 8.0.4.1514
BTW, a little trivia: the Scott demo schema is named after Bruce Scott, one of the early Oracle developers, who created the scott/tiger demo schema for version 3 of the database. The password Tiger was the name of his cat.
