Unanswered: Query returning a null value instead of zero
I have a query that filters merchandise by month of arrival (query1) and then another query (query2) that adds the price of every single item that was filtered by the previous query. The problem is that if nothing arrives in one given month, the first query returns empty (no problem so far). Now comes the problem: when the first query returns empty, the second one still adds the prices but instead of saying that the total price of merchandise bought is zero, it also returns empty. How do I get around this problem? (I need the second query returning the value zero to make further calculations)
Last edited by franchico; 08-13-09 at 11:24.
Reason: explain myself better