Hello dont know if this has been answered before and it its im sorry.
The problem that i have is when a make queries of the following type:
Example:
Query works fine
Select a.date, b.initial_date, b.final_date
from table.name1 a,
(select initial_date, final_date
from table.name2
) b
where a.date between b.initial_date and b.final_date
It is not necesary with dates the problems but this is just an example, if I run that query that query works just fine but if I have a query like this.
Query does not work.
Select a.date, b.initial_date, b.final_date
from (select date
from table.name1
) a,
(select initial_date, final_date
from table.name2
) b
where a.date between b.initial_date and b.final_date
If I run this query it gives me an error that a right parenthesis is missing and if i run the same query in plus it works fine, if a use sql navigator 5.2 is works fine and so if I use another programs.
For your help thanks.
)