SyntaxFix
Write A Post
Hire A Developer
Questions
select tableA.id from tableA left outer join tableB on (tableA.id = tableB.id) where tableB.id is null order by tableA.id desc
If your db knows how to do index intersections, this will only touch the primary key index