Hi All,

I have a account table which has parent acct number, Customer name, Account number.

 the issue is  1 parent account number should have only one customer name even though account number is different like below

1 parent acc num // 2 customer name // 2 Accounts
1123456789 – NIKE – AAAAA1
1123456789 – NIKES -AAAAA2

but i need to update output like below for all parent account numbers which has different names,

=>> write the query to update that the data for customer name remains the same
1 parent acc num // 1 customer name // 2 Accounts
1123456789 – NIKE – AAAAA1
1123456789 – NIKE -AAAAA2

Could you please assist me to write an update quey to update 1 parent account number  has 1 customer name.

Thanks in advance for your support.

Regards,

Bhaskar

​Hi All, I have a account table which has parent acct number, Customer name, Account number. the issue is  1 parent account number should have only one customer name even though account number is different like below 1 parent acc num // 2 customer name // 2 Accounts1123456789 – NIKE – AAAAA11123456789 – NIKES -AAAAA2 but i need to update output like below for all parent account numbers which has different names,=>> write the query to update that the data for customer name remains the same1 parent acc num // 1 customer name // 2 Accounts1123456789 – NIKE – AAAAA11123456789 – NIKE -AAAAA2 Could you please assist me to write an update quey to update 1 parent account number  has 1 customer name.Thanks in advance for your support. Regards,Bhaskar    Read More

​