I understand that it's not possible to delete rows from separate tables with one DELETE query, but is it possible to refer to information in another table in the WHERE clause?
The situation is that I have one table of records, and another table which has several rows for each row of the first table. I have a list of rows in the first table which need to be deleted. This list does not use the same key column used to link these two tables. So I can delete the rows from the first table, but how can I delete the ones in the second table? (without querying the second table with a SELECT query to get the list)
Keegan
The situation is that I have one table of records, and another table which has several rows for each row of the first table. I have a list of rows in the first table which need to be deleted. This list does not use the same key column used to link these two tables. So I can delete the rows from the first table, but how can I delete the ones in the second table? (without querying the second table with a SELECT query to get the list)
Keegan