From 1d4938471e40586717e6a70a081c8d535f957cae Mon Sep 17 00:00:00 2001 From: Jesse Luehrs Date: Mon, 26 Aug 2019 02:03:41 -0400 Subject: fix --- data/schema.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/data/schema.sql b/data/schema.sql index 6478769..7424254 100644 --- a/data/schema.sql +++ b/data/schema.sql @@ -169,7 +169,7 @@ CREATE VIEW denorm_transactions AS ( payees.name AS payee, category_group_id, category_groups.name AS category_group, - category_id + category_id, categories.name AS category, transfer_account_id, transfer_accounts.name AS transfer_account @@ -223,7 +223,7 @@ CREATE VIEW denorm_scheduled_transactions AS ( category_groups.name AS category_group, category_id, categories.name AS category, - transfer_account_id, + scheduled_transactions_with_subtransactions.transfer_account_id, transfer_accounts.name AS transfer_account FROM scheduled_transactions_with_subtransactions LEFT JOIN accounts ON ( -- cgit v1.2.3-54-g00ecf