update query

[muumigirl]

I have 2 tabels-first one contains addresses and the other one contains firms. I need to add firm codes to the tabel that contains addresses.

Address tabel:
Street1 | house1
street1 | house1
street1 | house1
street3 | house5

Firm tabel:
firm1 | street1 | house1
firm2 | street1 | house1
firm3 | street1 | house1
firm4 | street3 | house5

right now just doing update remains:
Street1 | house1 | firm1
street1 | house1 | firm1
street1 | house1 | firm1
street3 | house5 | firm4

I need that it would add every firm just once
I need that the address tabel would stay like this
Street1 | house1 | firm1
street1 | house1 | firm2
street1 | house1 | firm3
street3 | house5 | firm4

 

[lupins46]

Why do need the address table at all?
The answer you say you want is the same as the existing Firm table.

 

[muumigirl]

Beacause adress table is more than only adress tabel and all main information what i need is in adress tabel and acually i dont want use firm tabel at all.