Which comparision operator is *=

Question

In Powerbuilder datawindow I a select query contains:

(~"abc~".~"year~" = ~"xyz~".~"year~" ) and  
( ~"abc~".~"number~" *= ~"xyz~".~"number~" )

I understand the equal operator is used in first line, but what does *= mean? Thanks.

Answer 1

Its an Outer join, Check the section "Join syntax and join processing" in this Documentation