Normalization of addresses

[nonmiviene]

Hello everyone.

i've got this question?

want to convert address in table A, address field, into address in table B, address field.

Table A,field address, record 7 = via G.Garibaldi
record 11 = via Garibaldi

Table B field address, record 15 = via Giuseppe Garibaldi

I have to modify record 7 and record 11 of Table A into via Giuseppe Garibaldi.

[BuezaWebDev]

Hello everyone.

i've got this question?

want to convert address in table A, address field, into address in table B, address field.

Table A,field address, record 7 = via G.Garibaldi
record 11 = via Garibaldi

Table B field address, record 15 = via Giuseppe Garibaldi

I have to modify record 7 and record 11 of Table A into via Giuseppe Garibaldi.

What are you running? MySQL? Oracle?

Try this:

sql> update tableA set fieldAddress = 'via Giuseppe Garibaldi' where recID = 7 and recID = 11;

[nonmiviene]

thanks but is not the way.

Think of a table with these 3 fields (tAB A)

name gender address

record 1: paul - m - john wayne street
record 25: peter - m - j.wayne st.
record 39: bill - m - st.j.wayne

AND tABLE B

record x, field address : j. wayne street (the right structure)

i have to create a new table in which record 1, table A, address field, become paul - m - "j. wayne street" (as written in table b);
record 25,table A, become : peter - m - "j. wayne street", etc.etc.