Break this into three queries. The first two, will each do one table and summarize the amounts by Category. Then the third query will combine the first two, by Category using the Category table as the "driver." It is important to use the LEFT JOIN from the Category table to each of...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.