ViewVC Help

View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing

root/public/ibx/trunk/examples/local-employeedb/patches/02-patch.sql

Comparing ibx/trunk/examples/local-employeedb/patches/02-patch.sql (file contents):
Revision 44 by tony, Mon Feb 15 14:44:25 2016 UTC vs.
Revision 45 by tony, Tue Dec 6 10:33:46 2016 UTC

#	Line 10 | Line 10 | Select DEPT_NO, DEPARTMENT, HEAD_DEPT, c
10		cast(DEPT_NO as VarChar(64)) as DEPT_KEY_PATH
11		From DEPARTMENT Where HEAD_DEPT is NULL
12		UNION ALL
13	<	Select DEPT_NO, DEPARTMENT, HEAD_DEPT, Depts.DEPT_PATH ||  ' / ' || DEPARTMENT as DEPT_PATH,
14	<	Depts.DEPT_KEY_PATH || ';' || DEPT_NO as DEPT_KEY_PATH
15	<	From DEPARTMENT
16	<	JOIN Depts On HEAD_DEPT = Depts.DEPT_NO
13	>	Select D.DEPT_NO, D.DEPARTMENT, D.HEAD_DEPT, Depts.DEPT_PATH ||  ' / ' || D.DEPARTMENT as DEPT_PATH,
14	>	Depts.DEPT_KEY_PATH || ';' || D.DEPT_NO as DEPT_KEY_PATH
15	>	From DEPARTMENT  D
16	>	JOIN Depts On D.HEAD_DEPT = Depts.DEPT_NO
17		)
18
19		Select A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,

Diff Legend

–	Removed lines
+	Added lines
<	Changed lines
>	Changed lines