When I make a JOIN with the Category and Subcategory tables and the transaction have a split it shows -1
How can i make the JOIN? I couldn't see any links in the database tables.
This is the query that I'm using:
Code: Select all
Select Bd.bdid, bd.TransDate, ac.AccountName, py.PayeeName, bd.TransCode, ca.CategName, sc.SubCategName, bd.NumOccurrences, bd.TransAmount, bd.Notes
from BillsDeposits_v1 AS bd
INNER JOIN Payee_v1 AS py
ON bd.PAYEEID=py.PAYEEID
INNER JOIN AccountList_v1 AS ac
ON bd.AccountId=ac.AccountId
INNER JOIN Category_v1 AS ca
ON bd.CategId=ca.CategId
INNER JOIN SubCategory_v1 AS sc
ON bd.SubCategId=sc.SubCategId
Order By Bd.bdid Asc