Delete join
Ciaooo.
![:smile5: :smile5:](https://image.searchon.it/rx/1040x560/https://connect.gt/plugins/nodebb-plugin-emoji/emoji/customizations/1881713c-5c09-4986-bf15-fa308ef84b2e-smilegt.gif?v=gooep8f9m6s)
Ho creato 2 tabelle:
categorie
id_cat 1 2
nome Mare Monagna
news
id 1 1 1
id_cat 1 1 1
testo Bello Brutto Carino
Fin qui' tutto ok.
Ma come faccio ad eliminare una categoria con le rispettive voci in news?
DELETE FROM categoria,news
WHERE categoria.id_cat=news.id_cat
![:gthi: :gthi:](https://image.searchon.it/rx/1040x560/https://connect.gt/plugins/nodebb-plugin-emoji/emoji/customizations/0541d916-a420-403e-bd97-1a1367eebdcf-hi-1.gif?v=gooep8f9m6s)
Grazieeee