I have the follwing Oracle query and I want to move the joins from the *Where* clause to the *From* clause

```
select 
    * 
from
    A, B, C
where
    A.a (+)= B.a
    AND A.b (+) = B.b
    AND A.b = C.b;

```

So I came up with the following query

```
select
    *
from
    C,
    B left join A on (B.a = A.a and B.b = A.b and C.b = A.b);

```

I want to know if the two queries are semantically the same and if both will output the same results

\*\*\* Edit: Attempt 2

```
select
    *
from    
    B left join A on (B.a = A.a and B.b = A.b)
    inner join C on C.b = A.b;

```