get record which is available in one table but not in another mysql

Solutions on MaxInterview for get record which is available in one table but not in another mysql by the best coders in the world

showing results for - "get record which is available in one table but not in another mysql"
Emery
22 Mar 2020
1SELECT  *
2FROM    Call
3WHERE   phone_number NOT IN (SELECT phone_number FROM Phone_book)