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"

1SELECT  *
2FROM    Call
3WHERE   phone_number NOT IN (SELECT phone_number FROM Phone_book)

similar questions

print all records of table in mysql sql values not in another table mysql select tables with name like select tables with name like mysql mysql count all table rows mysql check table exists mysql find duplicates in same table mysql query single row find how many table doesn 27t contain column in mysql select from one table where not on the other mysql find tables with name how to query all tables mysql at the same time return the number of records in a single table mysql how to check which table has data in mysql mysql search for column name in all tables mysql update from select on same table how to select specific table data from an mysql databse server 3a mysql get latest duplicate rows mysql find the row ites of the hoghest value at on column sql select where id not exists in another table mysql query to check record exists in database table or not how to get button for every record from mysql copy data from one table to another mysql get rows from 1 table with other table empty mysql get only one row in mysql mysql get all tables row count get number of rows in every table mysql check if record exists mysql

queries leading to this page

mysql find rows from one table if value exists in another table get record which is available in one table but not in another mysql mysql find records not in another table how to get all records in mysql which exists in another table how to get only record which is not in another table mysql mysql select records appearing in one table not in another get record which is available in one table but not in another mysql