Need Help for sum statement

[eluser]Matalina[/eluser]
You results are going to depends on how your database is set up. I wouldn't suggest summing two fields from two different tables in one query like that.

Can you explain what you are trying to do? I think I understand, but I want to make sure before I give you code to help. Basically it's going to come down to a subquery inside of the select statement. But it may not be what you want either.