i’m not sure you actually meant to say this – maybe you meant to say something else, but what you said doesn’t make sense
first of all, there is no editing involved, just deleting joined rows
secondly, if you believe that the join produces a temporary table from which no rows can be deleted, can you explain why the mysql engineers implemented the following syntax?
Do you can give me example from my query in first post’s?
table_1.id => this have id 65 table_2.rela => this have rela 65 table_2.h_id => this have h_id 11 table_3.h_id => this have h_id 11 table_4.rela => this have rela 65 table_5.h_id => this have h_id 11
No all related rows, in tour_foreign.id one row have 65 and also is for tour_foreign_residence and tour_foreign_image that have relation 65 (tour_foreign.id = tour_foreign_residence.relation => 65 = 65, tour_foreign.id = tour_foreign_image.relation => 65 = 65,) now in tour_foreign_residence we have a column name hotel_id that have number 11 and it is set with hotel_id in tables[tour_foreign_units, tour_foreign_prices_changing].
How with there this relationship can get a id from tour_foreign and delete other rows in other tables.
i mane is this: (with have one id from tour_foreign we can delete other rows relationship with it in tables their, in following is a example from this relationship)