Unfamiliar query symbo...

[pdbowling]

Hello all,
I ran across this 'Where clause' and didn't recognize one of the symbols

WHERE
MAXIMO.V_INVENTORY.ITEMNUM (+) = MAXIMO.V_POLINE.ITEMNUM

What is (+)= doing?

Thanks all
PB

 

[namliam]

it is (i am 95% sure) the Oracle way of doing a Left (outer) Join

Eg showing all records from your V_Poline table even if there is no data in your V_Inventory table. (may need to reverse the table names, and then it would also be named a Right (outer) Join) Not as sure on that part. But is is an Outer Join thing...

Regards