I need some help writing a delete query which deletes data from 3 different tables - tried to read up about it but could quite make sense of it.
table dives (main table)
diveid, otherfields, profileid
table profile_data (Index on profileid)
dataid, profileid, otherfields
Given a diveid, I want to delete the row from
dives as well as the corresponding row in
profiles (dives.profileid = profiles.profileid) along with all the corresponding rows in
profile_data. (dives.profileid = profile_data.profileid)
Thanks in advance!