Nested notexists join

Hi All,

I have a requirement where i insert data from 3 parent tables into a child table.I need to use nonexists join to delete relevant record from child table if the records has been deleted in any of the parent tables.Is it possible to use nested notexists join? Kindly advise.

Thanks and Regards,

Gaya3

Hi Gayathri,

Instead of writing code why don’t you use Delete Actions in table level. In Parent table you can give the child table as a cascade action.

Regards,

Abbas

Hi Abbas,

I am used to delete actions so this time i thought I’ll try out using not exist join :slight_smile:

Thanks and Regards,

Gaya3