get record which is available in one table but not in another mysql code example
Example: get record which is available in one table but not in another mysql
SELECT *
FROM Call
WHERE phone_number NOT IN (SELECT phone_number FROM Phone_book)
SELECT *
FROM Call
WHERE phone_number NOT IN (SELECT phone_number FROM Phone_book)