J
Judson Mitchell
Guest
Is it possible to display the results of a select query? E.g, I have a table called Contributors and a field called Contribution_Amount. The SQL statement SELECT Sum(Contribution_Amount) FROM Contributors obviously returns the total of the column which is the info I'm looking for. How can I get DADABIK to display this total?
Moreoever, assume there is another field called Type. How can I display the results of WHERE Type="some value". That is the full statement would be,
SELECT Sum(Contribution_Amount) FROM Contributors WHERE Type="some value".
Any help is greatly appreciated.
Moreoever, assume there is another field called Type. How can I display the results of WHERE Type="some value". That is the full statement would be,
SELECT Sum(Contribution_Amount) FROM Contributors WHERE Type="some value".
Any help is greatly appreciated.