SQL SELECT SUM Problem

You are aware of that the SUM function accumulates for all rows in the table
where the WHERE condition is true ?

Hi arne

Yes I am aware and what I need is that to add all rows in that table where there is true in paid

Thanks

Are you missing some JOIN conditions ?

WHERE (P.Paid = True) AND (S.afield = P.afield) AND (S.anotherfield = B.anotherfield)

?

Hi
Are you missing some JOIN conditions ? Yes ... No... May be
but I am trying to make SQL Query that calculates data from three Tables these 3 tables hav't any relations between them so I don't think it should good idea to make any JOIN.

ex. take two fileds from Send table, take one field from Pay and one from Bank
add the first two and substract the other two that i have allready added together.

Thanks

You must join all 3 tables. Otherwise your result will be garbish!

If it is SQLServer or similar SQL dialect you may be able to do something like:

SELECT (((SELECT SUM(LLQD) FROM Send) + (SELECT SUM(KM) FROM S)) - ((SELECT SUM(LLQD) FROM PAY WHERE Paid) + B.AMO))

[untested - check use og brackets]

I forgot the last:

SELECT (((SELECT SUM(LLQD) FROM Send) + (SELECT SUM(KM) FROM S)) - ((SELECT SUM(LLQD) FROM PAY WHERE Paid) + (SELECT AMO FROM Bank)))

Hi

I will try that and reply latter on

Thanks in advance

Hi

It did n't work but Í solved the problem in other way

Thanks for your time and suggestions you can have the Points arene v

Thanks

then I will put in an answer

Time to accept the answer ?

I clicked the accept button so many times but stil it seems that the question is not closed yet, but anyway i accepted comments/answers of arne_V.

Thanks

It is accepted now.

What usuallly tricks peoples is that ven though there are only one
answerer, then just clicking accept do not have any effect. You still need
to mark that one answerer and then click accept.