This is something I can't find any data on.
I've got two database. Database one has a list in it. Database 2 has a list in it as well. I am needing to delete all the entries from database 1 that database 2 also contains. So if database one had entries 1, 2, and 3, while database 2 had entries 2, 3, and 4, Database 1 would delete rows 2 and 3 while database 2 would still do nothing.
Is this even possible? This would make a system I have built at least 1000% more efficient.
Thank in advance for any help,