Opposite Of An Inner Join Query April 22, 2023 by Tarik Select * from table1 left join table2 on table1.id = table2.id where table2.id is null