Update query

S

Stephanie

I'm trying to write an update query by joining two tables
together on a common field and updating the field in one
table using the values in a field of the second table.
However, I am unable to use more than one table when
writing the update query. Design view of the stored
procedure will only allow me to use one table. Any ideas
about how to perform this update in my .adp database?
 
G

Gérard Ducouret

Hello Stephanie,
Try to post in a SQLServer news group
Hope you'll find help,

Gérard Ducouret
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Migrating from 2010 to 2013 - having issues: Exporting to xml 0
QBF & Query Malfunction 0
Some mail merge fields not pulling into document 2
update query vs make query 5
ASK Field Formatting 1
Report Query Works 2nd Time, But Not 1st 14
Cross-reference Insert Default Change 0

Top