From 1b6db03c7c77f502dd3cd96b434c0cb1a74eb38f Mon Sep 17 00:00:00 2001 From: erickson Date: Mon, 24 Nov 2008 22:19:33 +0000 Subject: [PATCH] repaired column name git-svn-id: svn://svn.open-ils.org/ILS/trunk@11324 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/100.circ_matrix.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/100.circ_matrix.sql b/Open-ILS/src/sql/Pg/100.circ_matrix.sql index 71f05e829a..6a3226bc36 100644 --- a/Open-ILS/src/sql/Pg/100.circ_matrix.sql +++ b/Open-ILS/src/sql/Pg/100.circ_matrix.sql @@ -306,7 +306,7 @@ BEGIN FOR standing_penalty IN SELECT DISTINCT csp.* FROM actor.usr_standing_penalty usp - JOIN config.standing_penalty csp ON (csp.id = usp.penalty) + JOIN config.standing_penalty csp ON (csp.id = usp.standing_penalty) WHERE usr = match_user AND usp.org_unit IN ( SELECT * FROM explode_array(context_org_list) ) AND csp.block_list LIKE penalty_type LOOP -- 2.11.0