Created On: 29 March 2011
Problem:
I was running a query within XDB Wizard that contained LEFT OUTER JOIN.
Example:
SELECT C.NAME, C.STATE
FROM EMPLOYEES
LEFT OUTER JOIN EMPLOYEE_TEST
ON C.EMPLOYEE_ID = ST.EMPLOYEE_ID;
However, running a query with LEFT OUTER JOIN returns incorrect results.
Example:
SELECT C.NAME, C.STATE
FROM EMPLOYEES
LEFT OUTER JOIN EMPLOYEE_TEST
ON C.EMPLOYEE_ID = ST.EMPLOYEE_ID;
However, running a query with LEFT OUTER JOIN returns incorrect results.
Resolution:
This is supported in WebSync 06 and up to the current updates available for Mainframe Express 3.1.
Incident #2507027
Old KB# 33798
#EnterpriseDeveloper
#MFDS
