Categid, Categname, Subcategid ,Subcategname, Absolute amount (from the budget table), sum(transamount) from the Checking account table and exclude subcategid '98' and '99.
This is the query I wrote but am getting a syntax error. Could someone help me please?
Code: Select all
SELECT c.categname, sc.subcategname, ABS(b.amount) as Budget, subquery1.Actuals
FROM budgettable_v1 b, (SELECT a.categid categ, a.subcategid subcateg, SUM(a.transamount) as Actuals from checkingaccount_v1 a where subcateg not in (‘98’,’99’) group by categ,subcateg) subquery1, category_v1 c, subcategory_v1 sc
WHERE subquery1.categ = b.categid and subquery1.subcateg = b.subcategid and c.categid = b.categid and sc.subcategid = b.subcategid
GROUP BY b.categid, b.subcategid
ORDER BY b.categid, b.subcategid;