Updating an Aliased table

  • Thread starter Thread starter John Kraus
  • Start date Start date
J

John Kraus

How do you update all of the records in an aliased table that is part of a
query? I have a real table (that the aliased ones were created from) that
contains record changes that I want passed to the aliased ones.

John Kraus
 
Update over a join or over a query that join the two tables.


In the first case, that is something like:

UPDATE oldStuff RIGHT JOIN newStuff ON oldStuff.id = newStuff.id
SET oldStuff.id=newStuff.id,
oldStuff.UnitPrice = newStuff.UnitPrice,
oldStuff.Description = newStuff.Description




Hoping it may help,
Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Alias a tool for shortening long commands 2
Column aliases use literal not alias in Group By 2
Alias 1
Getting records returned that don't match criteria (Oracle) 5
Selecting the same field more than once 2
an ALIAS question? 2
Alias outfield column header 3
How do I display fonts in MS Word 2007 as NON anti-aliased? 1

Back
Top