On 01/09/2017 01:33 AM, Job wrote:
> Hi guys,
>
> Really thank you.
> Thanks to your help i solved the problem.
For the record which problem(s)?:
1) Your original function issue.
2) The stand alone query you showed later.
3) Both.
>
> As said by Adrian:
>
>>> Caveats, it is morning here and coffee is still brewing, but I am not following. The left join limits grulist.stato
toNULL, 1, 2. Your first condition catches the 1 value. Should not the second 'and' be (stato = 2 or stato is >>
>>> null). In fact I do not see why it needs to exist at all, which seems to be borne out by your experimentation.
>
> O doubled conditions, without reason!
>
> I think making good queries is an art, at the moment i am not an artist! :)
>
> Again,thank you very much!
>
> /F
>
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com