Re: Oracle SQL Query (help/question about Oracle "HINTS")

Antony wrote:
> Hi, I have the following query that gives the correct answer.
>
> SELECT a.f1,a.f2,a.f3
> FROM a,b
> WHERE a.f7=16
> AND fn_calculateMovingRate(a.f1,b.fAX) > 65
> AND fn_calculateDAR(a.f1,b.fDAR) > 16
> AND a.f7=16
> ORDER BY a.f1 ASC, a.f2 ASC, a.f3 ASC;
>

< snip >
> Thank you
> Tony

Tony

Is the SQL as you intended ?
You have a.f7=16 twice and I was expecting a JOIN to table/view b.

eric

--

Remove the dross to contact me directly