From 7258a0462e83956ef742c8d545f63aa34665a368 Mon Sep 17 00:00:00 2001 From: miker Date: Wed, 26 Sep 2007 18:28:35 +0000 Subject: [PATCH] it would seem that "do" is reserved ... never seen that one before git-svn-id: svn://svn.open-ils.org/ILS/trunk@7844 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/examples/fm_IDL.xml | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml index 8ccd7e4024..e2103632e1 100644 --- a/Open-ILS/examples/fm_IDL.xml +++ b/Open-ILS/examples/fm_IDL.xml @@ -2589,9 +2589,9 @@ SELECT t.* FROM action.transit_copy t - JOIN actor.org_unit AS so ON (t.source = so.id) - JOIN actor.org_unit AS do ON (t.dest = do.id) - WHERE so.parent_ou <> do.parent_ou + JOIN actor.org_unit AS s ON (t.source = s.id) + JOIN actor.org_unit AS d ON (t.dest = d.id) + WHERE s.parent_ou <> d.parent_ou -- 2.11.0