Re: calculating a column´s value from two registries

[Ramalingam Chelliah]

Hi ,
You have not given table description or which tables you joined ....

But here is a hint ....

To the previous query JOIN (Prefer LEFT OUTER JOIN )
more (same) table(s)
( for getting Year ,Month,concept,Payment) but
ON condition that Month is same ,concept is same, Year =Year+1

Then subtract the values of Payment .....

Hope this helps you...

Regards,
Ram.

P.S:

Suppose if I have table 'sample' with fields Year,Month,Value
Then

SELECT X.Year,X.Month,X.Value,(X.Value-Y.Value) as 'Annual Profit'
FROM
sample as X
LEFT OUTER JOIN
sample as Y
ON X.Month=Y.Month AND X.Year=(Y.Year+1) ;





We Learn the Most When we have to Invent