Create a Scheduled Job which matches items from two tables and writes to a third table
(function() { var table1 = new GlideRecord('x_table_1'); table1.addEncodedQuery('copy Query from show/hide filter'); // This is optional if you want to filter for specific records in a large table to save time. table1.query(); ...