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

    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
    Croatia, Europe
    Provided Answers: 5
    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