Kbase 18184: Using SQL Outer Joins in Apptivity
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/08/2003 |
|
Status: Unverified
FACT(s) (Environment):
Apptivity
SYMPTOM(s):
Using "*=" syntax or LEFT OUTER and RIGHT OUTER syntax, results in the following parser error:
Error: "Parsing of the given SQL statement failed".
CAUSE:
The syntax for outer joins does not work in the Apptivity query editor.
FIX:
To use outer joins in Apptivity, you can perform your outer join in a database view and then have the Apptivity data source reference that view. This is assuming that the target database supports views.