--- ibx/trunk/examples/local-employeedb/patches/02-patch.sql	2016/09/22 17:10:15	44
+++ ibx/trunk/examples/local-employeedb/patches/02-patch.sql	2016/12/06 10:33:46	45
@@ -10,10 +10,10 @@ Select DEPT_NO, DEPARTMENT, HEAD_DEPT, c
 cast(DEPT_NO as VarChar(64)) as DEPT_KEY_PATH
 From DEPARTMENT Where HEAD_DEPT is NULL 
 UNION ALL
-Select DEPT_NO, DEPARTMENT, HEAD_DEPT, Depts.DEPT_PATH ||  ' / ' || DEPARTMENT as DEPT_PATH,
-Depts.DEPT_KEY_PATH || ';' || DEPT_NO as DEPT_KEY_PATH
-From DEPARTMENT  
-JOIN Depts On HEAD_DEPT = Depts.DEPT_NO
+Select D.DEPT_NO, D.DEPARTMENT, D.HEAD_DEPT, Depts.DEPT_PATH ||  ' / ' || D.DEPARTMENT as DEPT_PATH,
+Depts.DEPT_KEY_PATH || ';' || D.DEPT_NO as DEPT_KEY_PATH
+From DEPARTMENT  D
+JOIN Depts On D.HEAD_DEPT = Depts.DEPT_NO
 )
 
 Select A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,