Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Updating multiple tables using SQL UPDATE

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-04-03 : 09:54:04
Adil writes "How can I update fields in multiple tables using SQL UPDATE query statement, the tables are joined by foreign keys.

How can I use joins in update query to update multiple tables"

Jay99

468 Posts

Posted - 2002-04-03 : 09:59:29
Update statements change existing data in one table. Joins may be used to determine which rows to update.

Jay
<O>
Go to Top of Page
   

- Advertisement -