Search
 
SCRIPT & CODE EXAMPLE
 

SQL

join to find results not in another table

SELECT t1.name
FROM table1 t1
LEFT JOIN table2 t2 ON t2.name = t1.name
WHERE t2.name IS NULL
Comment

PREVIOUS NEXT
Code Example
Sql :: mysql config user password 
Sql :: hotw to alter lengh character vayng postgres 
Sql :: cast to float with .2 sql 
Sql :: array out of range mql4 
Sql :: datetrunc 
Sql :: how to pass password mysql command line 
Sql :: sql create table primary key autoincrement 
Sql :: purge undo tablespace usage 
Sql :: how to drop a database in sql server when it is in use 
Sql :: show columns in sql 
Sql :: sql order by case 
Sql :: tsql row number 
Sql :: datepart postgres 
Sql :: sql rank 
Sql :: drop unique key constraint in sql server 
Sql :: insert data from another table 
Sql :: SQL loop with cursor 
Sql :: check if record exists mysql 
Sql :: join update query in sql 
Sql :: is mysql and sqlite same 
Sql :: mysql change auto_increment start value 
Sql :: postgres copy table from one schema to another 
Sql :: how to import large sql file in phpmyadmin in ubuntu 
Sql :: how to unlock table in sql server 
Sql :: how to find sql server agent jobs related to a database 
Sql :: sqlalchemy join on column 
Sql :: concatenate two strings in sql 
Sql :: error code 1451 sql 
Sql :: sql stored procedure with output parameters 
Sql :: sql case 
ADD CONTENT
Topic
Content
Source link
Name
7+7 =