Error using a view created in Oracle 8.3

[benr]

Hi All,<br>
<br>
I'm building reports that gets its data from Oracle 8.3 through Intersolv ODBC driver. <br>
<br>
I've created a view (fairly complex one) where subqueries and union are involved. When i run the view in Oracle ( select * from view) all is OK. The data appears.<br>
<br>
My problem is when I run the view from Crystal Report. I get the message &quot;ORA-01789:Query block has incorrect number of result columns&quot;. <br>
<br>
I've check number, name and type of columns and they match.<br>
<br>
Am I missing something?<br>
<br>
Thanks for your replies.

 

[benr]

I found what the problem...<br>
<br>
When using subqueries, alias for tables should all be different otherwise the driver ODBC seems to misread/mix them.<br>
<br>
I fixed that and now it works.<br>
<br>
Weird... <br>