Hi

Is it possible to delete joined records from multiple tables in a single SQL statement for MS Access?

EG:

Code:
DELETE clients.*, bookings.* FROM clients, bookings WHERE clients.clientid=bookings.clientid and clients.clientid = 777
Or

Code:
DELETE clients.*, bookings.* FROM clients INNER JOIN bookings On clients.clientid=bookings.clientid WHERE clients.clientid = 777
This would seem to be the logical syntax, but it doesn't work.

Obviously I can write two delete statements one for each record based on the [clientid] field, but this strikes me as a messy solution.