Results 1 to 2 of 2

Thread: update cross three table

  1. #1
    Join Date
    Jul 2003
    Posts
    421

    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.

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    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
  •