Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2011
    Posts
    18

    Question Unanswered: Update with joins

    Can i perform an update on two tables at once? These two tables have in common information (COD_PROD).

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Generally speaking, no.

    But, if you create a view based on these tables, create INSTEAD OF trigger and issue UPDATE statement on a view, then the trigger will update these tables - if you write it that way.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •