<div>
<br />

<pre><code id="code-310910">update address
set county = d.county
from address a
inner join demographics d on a.city = d.city and a.stateabbreviation = d.stateabbreviation and a.postalcode = d.postalcode
</code></pre>
</div>





update address
set county = d.county
from address a
inner join demographics d on a.city = d.city and a.stateabbreviation = d.stateabbreviation and a.postalcode = d.postalcode


<div>
thanks but I get the following error when I run the statement<br />
<br />
Sql Command not properly ended, Line 2 Column 21
</div>


thanks but I get the following error when I run the statement

Sql Command not properly ended, Line 2 Column 21

<div>
And d.country should be d.county...
</div>


<div>
That saved me from having to look at about 102,000 records in our database! &nbsp;Thanks!!!!!!!!!!!!!!!!!
</div>


That saved me from having to look at about 102,000 records in our database!  Thanks!!!!!!!!!!!!!!!!!

<div>
<div class="content wysiwyg-content">
I have taken over a legacy system that now requires addresses to have the county name stored with them. &nbsp;I have obtained a database with the city, stateabbreviation, county and postalcode in them, Imported the data into oracle 10g with the table name DEMOGRAPHICS<br />
Now I need to update my Address table to fill in the county field<br />
where the City, StateAbbreviation, PostalCode fields in the DEMOGRAPHICS = the City, StateAbbreviation, PostalCode fields in the Address Table. &nbsp;Filling in the County field in the Address table with the County field in the DEMOGRAPHICS table
</div>
</div>


I have taken over a legacy system that now requires addresses to have the county name stored with them.  I have obtained a database with the city, stateabbreviation, county and postalcode in them, Imported the data into oracle 10g with the table name DEMOGRAPHICS
Now I need to update my Address table to fill in the county field
where the City, StateAbbreviation, PostalCode fields in the DEMOGRAPHICS = the City, StateAbbreviation, PostalCode fields in the Address Table.  Filling in the County field in the Address table with the County field in the DEMOGRAPHICS table

How do I update a field in one table from a field in another table in orabcle

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.