Conditional Join

Fri, 19 Jul 2013 10:01:56 GMT

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 !

Re: Conditional Join

Fri, 19 Jul 2013 10:10:35 GMT

Use left Join..

Those are matching that will join..