I have 3 tables . the tables are connected with Foreign keys
I want to delete some records but as they are interconnected by foreign keys i have to delete all of the dependencies.
I want a query like below but this does not work
delete from tableA , tableB , tableC where tableA.w = tableB.m and tableB.r =tableC.s AND tableA.y=5
i think this way i can remove the records from the above 3 tables which are connected by foreign keys
but that query is not correct .......can you make my query correct ?