Using SQL to find foreign key violations

Today I learned how to find and filter out rows from a query that violate a foreign key constraint on the table I am inserting data into. Now I can insert data without using INSERT IGNORE Given we are inserting data from a legacy system table with no constraints into a new system table with […]