If you are not using foreign key constraints , you could do two statements on a single command:
DELETE FROM ChildTable; DELETE FROM ParentTable;
But in effect that is two statements.
You could put a trigger on the ChildTable that deletes parent records on deletion of child record.
I think it will help you. If you are trying any query, post query.
Posted On: 16-Feb-2017 22:59