Conditional Join

[#1]

Hi All,

I want to join between a table & excel on some conditions.

Conditions:

1. If ID is matching then join with ID

2. If ID is not matching then join with name

Table:

Load

     Name,

     Id,

     City,

     *

from Table.

Excel:

Load

     Name,

     Id,

     Address

from Excel.

I used with resident but in that the name will be duplicated since excel has some duplicate records which i dont want.

Can anyone help.

Thanks in advance !

[#2]

Use left Join..

Those are matching that will join..