I have parent and child tables. How to I delete a parent table row, if there is no entry in child table for that particular parent entry. Fox Example: I have a parent table for Account Heads. The child table is called Transactions. Now If I want to delete one Account Head in Master Table, I need to check in Transactions table, if any entries there related to Accounts Head Table. How can I achieve this?
User | Count |
---|---|
14 | |
11 | |
9 | |
7 | |
4 |