copying a field from a table to new one

[#1]

i have two table

table1:

customer_id

customer_name

field1

field2

table2:

customer_id

field3

field4

customer_id is same for table1 and table2

and i want to add customer name to table2 from table 1, and it will also stay in table1

thanks

[#2]

i want to create

table1:

customer_id

customer_name

field1

field2

and

table2:

customer_id

customer_name

field3

field4

[#3 · Accepted solution]

Hello, pardon my english.

I think what you could get this result by a join of Table 2 to Table 1.left join(table2)

table1:

customer_id

customer_name

field1

field2

table2:

customer_id

field3

field4

join(table2)

Load customer_id,

customer_name

resident table1;

The problem with this application, which will create a synthetic 2-key two fields (customerID, customerName).

I hope I've been helpful.

A greeting.

[#4]

thanks a lot

[#5]

Merakist,

I didn't understand what you exactly want.

If you want all these columns in a single table like below

customer_id

customer_name

field1

field2

field3

field4

as per your data yo need to join bothe tables like this

table1:

customer_id

Load customer_name

,field1

,field2

from table1.qvd;

Join(table1)

Load customer_id

,field3

,field4

from table2.qvd;

Hope it helps you..

Regards

Ravikumar