Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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

SELECT ID, Name 
FROM   Table1 
WHERE  ID NOT IN (SELECT ID FROM Table2)
Comment

PREVIOUS NEXT
Code Example
Sql :: sql menampilkan data tabel 
Sql :: default order by in mysql 
Sql :: sql how to get courses that i have made prerequisites 
Sql :: Jenkins SQLCMD run 
Sql :: select month from date in sql 
Sql :: like in openquery 
Sql :: MySQL Min And As 
Sql :: Every Derived yable must have its own alias 
Sql :: no query unable to fetch row sqlite 
Sql :: sql server convert string list integers list 
Sql :: how to set all the min and sec data to zero in sql server 
Sql :: sql dmv to capture updates 
Sql :: how to make letter id primary key in mysql 
Sql :: inserting values with beekeeper get error null value in column createdAt violates not-null constraint 
Sql :: openquery update linked server 
Sql :: mysql table inspector command line 
Sql :: undefined get_magic_quotes_gpc() in sqlite 
Sql :: what is logical database schema 
Sql :: big table in mysql 
Sql :: sql query tags 
Sql :: sql start with vowels 
Sql :: unique veri seçme SQL 
Sql :: t sql list week start date and end date for a year 
Sql :: azure sql-datenbank 
Sql :: which is the order of precedence among following operator IN OUT AND OR in sql 
Sql :: declare row variable sql server 
Sql :: like date sql server not working 
Sql :: date to month name in mysql query 
Sql :: look at running processes redshift 
Sql :: sqlite display headers on columns 
ADD CONTENT
Topic
Content
Source link
Name
5+5 =