How To Implement The Logic In Procedures If The Source Side Data Dele

1.	How To Implement The Logic In Procedures If The Source Side Data Deleted That Will Reflect The Target Side Table?
Answer» USER this query on COMMAND on target Delete from Target_table where not exists (SELECT ‘X’ From Source_table Where Source_table.ID=Target_table.ID). User this query on Command on target Delete from Target_table where not exists (Select ‘X’ From Source_table Where Source_table.ID=Target_table.ID).

How To Implement The Logic In Procedures If The Source Side Data Deleted That Will Reflect The Target Side Table?

Answer»

USER this query on COMMAND on target Delete from Target_table where not exists (SELECT ‘X’ From Source_table Where Source_table.ID=Target_table.ID).

User this query on Command on target Delete from Target_table where not exists (Select ‘X’ From Source_table Where Source_table.ID=Target_table.ID).