Post reply

update query on multiple tables

  • October 14, 2009 at 7:20 pm

    #136462

    Hi,

    Need help with update query that updates multiple tables

    where the primary key of the first table is foreign key in second table

    Thanks

  • October 14, 2009 at 8:18 pm

    #1066070

    Unless you're trying to change the key fields, what's the problem? Or are you trying to work out how to control INSERTS to tables related with foreign keys?

  • October 14, 2009 at 9:22 pm

    #1066072

    I am trying to work out how to control INSERTS to tables related with foreign keys,like some of the data may not be there when updated,while it was intial state in the second table

    How to check this

    Thanks for the help

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply