Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to update one field from other table

Status
Not open for further replies.
Cap2010

Cap2010

Programmer
Mar 29, 2000
196
CA
hi,

I want to update one field from other table

how do to do this in SQL Server 2000 and Oracle ?

Cap2010
 
Sort by date Sort by votes
Hi Cap2010,

Your question is a bit vague. Could you elaborate?

Dave29Palms
 
Upvote 0 Downvote
Or
Code: 
update a
set a.field = b.field
from a, b
where a.key = b.key
Greg.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Bill Doe
  • Locked
  • Question
PDO UPDATE too long to execute
Replies
1
Views
190
mikrom
mikrom
mmiah1982
  • Locked
  • Question
Extracting mutiple data items from DB with JSON string format column
Replies
2
Views
198
mmiah1982
mmiah1982
fredong
  • Locked
  • Question
Update upper row data with next row data that was detached partially from import.
Replies
6
Views
258
carp
carp
Tetol
  • Locked
  • Question
Update script is changing the number of records for the values updated each time I run the query
Replies
1
Views
184
carp
carp
szeiss
  • Locked
  • Question
Need to select the one value if it exists otherwise another value
Replies
4
Views
201
szeiss
szeiss

Part and Inventory Search

Sponsor

Back
Top