Could anyone advise, if would it be possible to write a single sql delete statement, which for each orderno in the order table below. Also deletes the records in the items tables, with the same orderno?
Or would I need to use two delete statements? or even use the inner join?
orderno: item: quantity:
7823 Danish pastry 13
7823 Apple pie 20
4633 Steak pie 100