OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Query: update fields in a table using another (Beginner's Q)

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
jolt
Newbie
Newbie


Joined: 15 Jun 2005
Posts: 1

PostPosted: Wed Jun 15, 2005 1:11 am    Post subject: Query: update fields in a table using another (Beginner's Q) Reply with quote

Hi, hope you don't mind a beginners question
on the Query window.

I'm looking for the best way to update the data in one table
using data from another table. (Table 1 is a MS Access table
connected via ODBC)

This is the setup:
Table 1 has the fields
ID, Name, Name2, Content, morefields

Table 2 has the fields
differentID, Name, Name2, Content

I would like to update the "Content" field in table 1 with
same field in table 2 whenever Name and Name2 both match.
In case there's more than one match I do not care which value
is used.

While I can do a query that displays the result the way I want,
I have not found out how to change values using a query.

Any hints?
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group