SELECT
accounts_split.accounts_splitid,
account_no.description as account_name,
account_catagory.description as type,
account_sub_catagory.description as sub_cat,
accounts_split.description,
accounts_split.tracking_number,
accounts_split.amount
FROM
accounts_split
Inner Join account_no ON account_no.account_noid = accounts_split.account_noid
Inner Join account_sub_catagory ON account_sub_catagory.account_sub_catagoryid = account_no.account_sub_catagoryid
Inner Join account_catagory ON account_catagory.account_catagoryid = account_no.account_catagoryid
