mysql - SQL Select all rows from FIRST_TABLE that are not displayed on SECOND_TABLE

Question

This question already has answers here: question from:https://stackoverflow.com/questions/65861678/sql-select-all-rows-from-first-table-that-are-not-displayed-on-second-table

Answer 1

NOT EXISTS is usually a good method:

select t1.*
from first_table t1
where not exists (select 1 from second_table t2 where t2.id = t1.id);