I want to add one field from one table to another table fields only.

[Anonymous]

Hi,

I want to add one field only and don't want to join both the tables. Only one field want to add in anther table. How is that possible. Please advice.

Ex: I have one table1 where some fields are there and another table2 where different fields are there. but only one field from the table2 would like to add in table1 fields.

Best,

Shubham Kumar

[vijay_iitkgp]

Hi Subham,

There is no option other tha join to add column .

You can do

Load

Key,

..

..

From table A

Left join

Load

Key,

Field (Column u want to add)

From Table B

Hope this will help you

[Sokkorn]

Hi Shubham,

Try function

concatenate[ (tablename ) ] ( loadstatement | selectstatement )

Regards,

Sokkorn Cheav