Hi,

I would like to know if can we update one table's values while we insert or update values of another table. Both these table have relation but can not be joined directly. They have to joined with the help of a third table which has a common key needed in the join relation.

Thanks for your replies.

Sriprasad Kannan.

Hi

You could you use a Trigger to update your intermediary table when inserting data into a different table (assuming that is what you want to do in order to keep the referential integrity between the three tables).

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.