|
|
|
|
|
Re: Unable to parse query [message #395500 is a reply to message #395451] |
Wed, 01 April 2009 12:06 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
So use 4.5 version - just rewrite the query!
In other words (and as an example), instead ofSELECT e.ename, d.dname
FROM EMP e left join DEPT d
ON e.deptno = d.deptno you'd haveSELECT e.ename, d.dname
FROM EMP e, DEPT d
WHERE e.deptno = d.deptno
[Updated on: Wed, 01 April 2009 12:09] Report message to a moderator
|
|
|
|
Re: Unable to parse query [message #395688 is a reply to message #395425] |
Thu, 02 April 2009 04:48 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Another trick you can try is create a view based on your query then query that in the report.
reports 4.5 might not know ANSI sql but it should know views (I'm guessing - never used that version).
|
|
|
|