DELETE Users, meet, tour FROM Users, meet, tour WHERE Users.uid=meet.desg AND meet.desg=tour.desg AND Users.uid='CCC';
i have try this command to to delete record from three table
i want to delete all the record of uid from user ,tour and meet at once.
Users table having a key uid which is common to all table.
in table Users, uid is primery key
and meet table having desg and tour having desg common field value
i.e. Users.uid=meet.desg=tour.desg are same desg in both table is foreign key
so how could i delete uid from Users table ,desg from tour and meet at once and all the record from these 3 tables
View Complete Post