SAS SQL "joinless" syntax

[SAS_Ryan]

My coding style is to explicity define inner/left joins. That said, I've increasingly run into code like this which is effectively an inner join:

Proc SQL;

Create table abc as

select *

from

table1 A,

table2 B

where

a.key = b.key and a.id = b.id;

quit;

I recently ran into this:

Proc SQL;

Create table abc as

select *

from

table1 A,

table2 B

where

a.key = b.key (+) and a.id = b.id;

quit;

Can someone tell me what the (+) is doing?

[Patrick · Accepted solution]

@SAS_Ryan

"Can someone tell me what the (+) is doing?"

That's Oracle syntax for implicit left or right joins.