How to join two table based on Where Condition -- Urgent

[brijeshvma]

Hi All

I have two table :

FirstTable:

A,

B,

C,

D

From Firstable;

SecondTable:

A

B

From SecondTable;

I want to join this tow table when FirstTable.B=SecondTable.B

Kindly help me on this

[kaushiknsolanki]

Hi,

Try this.

Load A,B,C,D From Table1

Left join

Load B,A as Table2A

From Table2;

Regards,

Kaushik Solanki

[Kushal_Chawda]

FirstTable:

load

A,

B,

C,

D

From Firstable;

inner join

load

A as a

B

From SecondTable;

[Digvijay_Singh]

Something like -

FirstTable:

Load A,B,C,D

From Firstable;

Left join(FirstTable)

Load A,B

From SecondTable

Where Exists (B)