Conditional Inner Join in Oracle

Vote count:

0

I have an issue regarding conditional inner join. Kindly have a look at the following sqlfiddle.

http://ift.tt/1alUn9f

Here i'm trying to get all the same name. but if in case the id is 1 then also get the same name and the name which has id of 0. Your help will be appriciated. thanks. here is the example

Table1 
Id           |            Name
1            |            A
2            |            B
3            |            C

Table2
Id           |            Name
1            |            a
2            |            b
3            |            c
0            |            d

Here is what i expect

A            |            a
B            |            b
C            |            c
A            |            d

Thanks in advance.

asked 1 min ago

Zeb-ur-Rehman

222

Conditional Inner Join in Oracle