select from one table where not on the other

Solutions on MaxInterview for select from one table where not on the other by the best coders in the world

showing results for - "select from one table where not on the other"
Yacine
29 Jun 2018
1SELECT id FROM a.table
2WHERE id NOT IN (SELECT b.id FROM b.id)
3