Deleting data from 2 tables
Posted: Wed Nov 12, 2003 2:29 am
Is there any way to delete data from two tables ?
I'm doing a search on two tables, displaying the data and giving the option to delete the displayed data.
Can I delete the data where table1.id = table2.id ?
Must I use two queries ? If so, how do I make sure that all the data is deleted.
I'm doing a search on two tables, displaying the data and giving the option to delete the displayed data.
Can I delete the data where table1.id = table2.id ?
Must I use two queries ? If so, how do I make sure that all the data is deleted.