karinos57
asked on
Update table
hi,
I need to update a table called "MyTable", this table has several columns but one of the columns may contain blanks sometime and i want to populate the blanks with onother column's data. Here is how it look like my table:
ID NAME TP_NAME LOCATION
20 ABC LLM12 NC
40 MOX XX14 WA
25 MMX AZ
88 XXX OH
45 LLP MO56 KS
So in this case, since TP_NAME for ID 25 is blank i would like to update it with the same data as the NAME (MMX). After the update, my table should look like this:
20 ABC LLM12 NC
40 MOX XX14 WA
25 MMX MMX AZ
88 XXX XXX OH
45 LLP MO56 KS
I need to update a table called "MyTable", this table has several columns but one of the columns may contain blanks sometime and i want to populate the blanks with onother column's data. Here is how it look like my table:
ID NAME TP_NAME LOCATION
20 ABC LLM12 NC
40 MOX XX14 WA
25 MMX AZ
88 XXX OH
45 LLP MO56 KS
So in this case, since TP_NAME for ID 25 is blank i would like to update it with the same data as the NAME (MMX). After the update, my table should look like this:
20 ABC LLM12 NC
40 MOX XX14 WA
25 MMX MMX AZ
88 XXX XXX OH
45 LLP MO56 KS
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER