From 8f2bec86c912350ee98f8af7c469857283dce03f Mon Sep 17 00:00:00 2001 From: miker Date: Mon, 18 Jun 2007 23:15:54 +0000 Subject: [PATCH] correcting cut-n-paste error on view redefinition git-svn-id: svn://svn.open-ils.org/ILS/trunk@7446 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/080.schema.money.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/080.schema.money.sql b/Open-ILS/src/sql/Pg/080.schema.money.sql index 68dc8184dc..c8bfa745a2 100644 --- a/Open-ILS/src/sql/Pg/080.schema.money.sql +++ b/Open-ILS/src/sql/Pg/080.schema.money.sql @@ -252,7 +252,7 @@ CREATE OR REPLACE VIEW money.open_billable_xact_summary AS FROM money.billable_xact xact JOIN pg_class p ON (xact.tableoid = p.oid) LEFT JOIN "action".circulation circ ON (circ.id = xact.id) - LEFT JOIN money.grocery groc ON (circ.id = xact.id) + LEFT JOIN money.grocery groc ON (groc.id = xact.id) LEFT JOIN ( SELECT billing.xact, billing.voided, -- 2.11.0