Normalization of addresses
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?
Originally Posted by nonmiviene
sql> update tableA set fieldAddress = 'via Giuseppe Garibaldi' where recID = 7 and recID = 11;
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)