how get data from database if id not found then search another column

Solutions on MaxInterview for how get data from database if id not found then search another column by the best coders in the world

showing results for - "how get data from database if id not found then search another column"

1SELECT ID, Name 
2FROM   Table1 
3WHERE  ID NOT IN (SELECT ID FROM Table2)

similar questions

sqlalchemy one column of two has to be not null get record which is available in one table but not in another mysql power bi find all ids not in other tables on sql table data exists find column name in database sql value exists in column fatal error 3a uncaught pdoexception 3a sqlstate 5b21s01 5d 3a insert value list does not match column list 3a 1136 column count doesn 27t match value count at row 1 in android sqlite add column if not exists get id if is not equal in certain table mysql search for column name in all tables search for column name in sql db when i don 27t know which table it is in find all tables where column name exists oracle search mysql database for column sql select where id not exists in another table mysql query to check record exists in database table or not could not find driver 28sql 3a select 2a from information schema tables where table schema 3d pics and table name 3d migrations and table type 3d 27base table 27 29 create a database with a specified name if it does not exist in the database server sql missing records from another table select all records where the customerid column has the value 32

queries leading to this page

how get data from database if id not found then search another column how get data from database if id not found then search another column