• Nice complicated question. I could do it easily putting two select statement (order & ordertable), before and after delete command. Scored 1 mark.

    Thanks.