(+) in the query

[sventevit]

Hello again

What is the meaning of '(+)' operator in the query, like:

WHERE ...
(("Table1"."Param1"="Table2"."Param1" (+)) AND ("Table1"."Param2"="Table2"."Param2" (+))) AND
...

 

[Casper]

the + sign means outer-join.

 

[4GLNewbie]

Yes. Right Outer or Left Outer, depends on the side of the "=" it is specified..