Answer |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
For outer joins in the 8.2 toolset you have to create expressions. e.g. if you want to create a join as follows: ... from tableA a, tableB b where a.Field1 *= b.Field1 then create an expression as follows: a.Field1 *= b.Field1 and 'A' Then put the expression in the criteria and have this expression equal to a constant 'A'. Then the SQL will look like ... from tableA a, tableB b where a.Field1 *= b.Field1 and 'A' = 'A' This will serve the purpose for your outer join. |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Business Applications Consultants |