Results 1 to 3 of 3
Thread: Deleting Joined records
Nov 24, 2008, 07:49 #1
- Join Date
- Oct 2003
- Tenerife, Spain / UK
- 0 Post(s)
- 0 Thread(s)
Deleting Joined records
Is it possible to delete joined records from multiple tables in a single SQL statement for MS Access?
DELETE clients.*, bookings.* FROM clients, bookings WHERE clients.clientid=bookings.clientid and clients.clientid = 777
DELETE clients.*, bookings.* FROM clients INNER JOIN bookings On clients.clientid=bookings.clientid WHERE clients.clientid = 777
Obviously I can write two delete statements one for each record based on the [clientid] field, but this strikes me as a messy solution.