I have a Delphi 5 app that passes data between a local paradox bde databse and a remote SQL Server 2000 database. I use ADO components to access the SQL data and Infopower components to access the BDE data. There is a table on each server, we'll call them BDEJobs and SQLJobs. Each has a unique two-field key of RSN & Date.
I would like to create a delete query that would delete all records on SQLJobs that do not have a corresponding record in BDEJobs.
Any ideas on the best way to accomplish this?