Search snippets
Browse Code Answers
FAQ
Usage docs
Log In
Sign Up
Home
SQL
join to find results not in another table
Mbo42
Programming language:
SQL
2021-05-13 07:54:57
0
Q:
join to find results not in another table
George
Code:
SQL
2021-07-21 21:22:31
SELECT t1.name FROM table1 t1 LEFT JOIN table2 t2 ON t2.name = t1.name WHERE t2.name IS NULL
0
Tags
table
tab
find
result
another
Related
use where instead of join
sql get all columns from one table but one from another inner join
concat two columns in sql server
mysql count multiple columns in one query
only join in sql
select from one table where not on the other
sql view where tables have same column name combine results
join multiple tables sql
comma seperated join mssql
how to make sure two tables have same exact data in sql
using multiple join in sql
sql inner join sprcific columns
sql check same row
join multiple tables in sql
mysql select and count left join
New to Communities?
Join the community