>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?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.