>>Hi Borislav
>>
>>>Make them to be equal.
>>and there is no problem with that, in the first select i want to sum all movements from last years, and in the second the current year movements, but all lines, not in group... take a look at my first question!!
>>
>>
>>>(I didn't see FROM clause in your first select).
>>Remove some lines to make it sample, and the from go away....
>>
>>Thank's
>>Joao Batista
>
>Can you post some example data and desired result from it?

I really appreciate when you ask for that. I've recently had the misfortune to work where example data is not provided and desired results are rarely known.