KS DB Merge Tools
 
for Microsoft Access
aka AccdbMerge
for SQL Server
aka MssqlMerge
for MySQL
and MariaDB
for SQLite
 

Compare ad hoc query result

1Click 'Open database(s)' toolbar button:

In the opened dialog 2specify database connectivity options and 3click 'OK':

4wait a bit for a progress:

5Click 'Query result diff' toolbar button:

In the opened Query result diff tab 6specify query text, 7key mapping option and 8click 'Run'.

Then 9specify unique key fields and 10click 'OK':

and get the result:

where you can 11apply additional filter to show only new and/or changed records: