Let join between two tables

[Anonymous]

Hi,

I have two tables.The structure as follows:

TAB1:

LOAD * INLINE

[OrderNo

1,

2,

3];

TAB2:

LOAD * Inline

[OrderNo,PId,Qty

1,0,12

2,0,13

];

My question is how to make a third table (Tab3) after making left join between these two tables.

The output of the Tab3 table will be:

OrderNo PId Qty

1 0,12

2 0,13

3 -,-

plz help me.

I have tried an application,attached for your review.

[ashfaq_haseeb]

Hi

Find the attached file.

Hope that helps

Regards

ASHFAQ

[#3]

Hello chadan,

take a look at my suggestion:

Regards, Roland