-
update cross three table
Is poosible to update cross three table
table 1 ,table 2 both have formid ;
and both table1 and table3 have UniversityN
thank you
________
Lincoln Ls Specifications
Last edited by sql; 03-06-2011 at 02:16 AM.
-
UPDATE statement can only update one table, however if you have foreign constraint defined between these tables with CASCADE option, then update will change data in FK columns as well.
Other option is to create trigger in first table to update other two tables.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|