Details
-
New Feature
-
Status: Open
-
Major
-
Resolution: Unresolved
-
1.10.0
-
None
-
OS: Windows 7 32-bit
Reporting tools: Crystal Reports 2008, Crystal Reports 2016
Description
Referring to section 13.4.3 of JSR-000221, please add support of escape syntax for an outer join.
e.g.,
SELECT `A`.`ID`, `B`.`ID` FROM {oj `dfs.tmp`.`A` `A` LEFT OUTER JOIN `dfs.tmp`.`B` `B` ON `A`.`ID`=`B`.`ID`}
Crystal Reports 2008 & 2016 use this escape syntax in their generated SQL statement for generic JDBC / ODBC drivers.