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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

UPDATE DATA FROM ANOTHER TABLE

Status
Not open for further replies.
Oppenhiemer

Oppenhiemer

Programmer
Jun 28, 2001
315
GB
I am wanting to update fields in one table - based on data stored in another table and was wondering what the SQL statement may look like ?

The two tables are linked via a common field, so maybe I need to use an EMBEDDED SQL statement for the WHERE clause and a variable placeholder for the value to be used in the update ?

Anyway, any help would be appreciated.

Opp.
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

stratao
  • Locked
  • Question
trying to read DB.ID from another computer
Replies
0
Views
123
stratao
stratao
Elroacho
  • Locked
  • Question
Max from union
Replies
0
Views
121
Elroacho
Elroacho
crazyvonzipper
  • Locked
  • Question
Det cx Grid Row Data
Replies
1
Views
63
svanels
svanels
tirf
  • Locked
  • Question
help on interbase database
Replies
0
Views
126
tirf
tirf
Gjj
  • Locked
  • Question
Problems with importing from external table
Replies
0
Views
56
Gjj
Gjj

Part and Inventory Search

Sponsor

Back
Top