In need of your help again.
I have to delete some records to make room on the host.
I have 2 tables, Rentals & Invoices.
I would like to delete records from the Rentals table and also delete the related invoice record in the Invoices table.
In my Rentals table I have an InvoiceId column that relates to the record in the Invoices Table.
How can I select records from 13/06/2012 to 13/06/2015 in the Rentals Table also deleting the associated records in the Invoice Table.
Your help is appreciated as always.