I have a couple of tables, one with Sources and one with Articles. I link the articles back to sources with a Source ID column in the Articles table.
What I'm wondering is if theres a simple way to delete all Articles records where the Source record it has in the Source ID column does not exist in the Sources table.
It seems like I should be able to do this with a single SQL statement, but I haven't been about to find how to do it. Right now I'm doing crazy loops through thousands of records to check for matches and delete ones that don't match.