> I tried the nested select to check the speed. I actually want to
> delete all the transactions and their corresponding TransactionItems
> and so this query was going to be
>
> Delete from TransactionItems ........
>
> That is why I considered a nested select as I could not delete
> with a join!

But you can delete with cascade foreign key.

SY, SD.