Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>In a comment, you supplied this sample data (I've created field names):</p> <pre><code> CompanyName CompanyYear Amount Website Contact starbucks 2009 100$ starbucks.com matt bucky starbucks 2010 200$ null null </code></pre> <p>Since you've said the company names match, something like this:</p> <pre><code> UPDATE tblCompany INNER JOIN tblCompany AS C2 ON tblCompany.CompanyName = C2.CompanyName SET tblCompany.Website = C2.Website WHERE tblCompany.Website Is Null AND C2.Website Is Not Null AND tblCompany.CompanyYear=2010 AND C2.CompanyYear=2009; </code></pre> <p>This assumes that you want to update 2010 records with data from 2009 records, and that for each company there's only one record for each year.</p> <p>To update the contact name, you'd run the query again, suitably altering the SET statement and WHERE clause:</p> <pre><code> UPDATE tblCompany INNER JOIN tblCompany AS C2 ON tblCompany.CompanyName = C2.CompanyName SET tblCompany.Contact = C2.Contact WHERE tblCompany.Contact Is Null AND C2.Contact Is Not Null AND tblCompany.CompanyYear=2010 AND C2.CompanyYear=2009; </code></pre> <p>If there are older records that might have useful data, it's possible to write some complicated SQL with subqueries that would do it all in one go, but I'd just do it with multiple runs of the same SQL, first comparing 2010 to 2009, then to 2008, then to 2007, etc. Eventually, there won't be any more Null records.</p> <p>(this also seems more like a StackOverflow question than a ServerFault one, but what do I know? I can never figure out what belongs where)</p>
    singulars
    1. This table or related slice is empty.
    1. POMs Access replace issue
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USDavid-W-Fenton
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COAgree on the SO move... also, I would make sure to remedy the root problem here so the same issue won't appear again in 2011 ^^
      singulars
      1. PO
      1. USOskar Duveborn
    2. COIt can actually be quite a difficult problem. I programmed an import for a client this past Spring that was basically a more complicated version of the same problem, but it was complicated because it was external data coming in that had to be matched up with existing data. It's a very common problem, and not subject to any simple solution.
      singulars
      1. PO
      1. USDavid-W-Fenton
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload