Search snippets
Browse Code Answers
FAQ
Usage docs
Log In
Sign Up
Home
SQL
select from one table where not on the other
pHred
Programming language:
SQL
2021-03-14 10:36:36
0
Q:
select from one table where not on the other
Arif Talukdar
Code:
SQL
2021-07-26 22:28:49
SELECT id FROM a.table WHERE id NOT IN (SELECT b.id FROM b.id)
1
Tags
table
tab
select
Related
mysql delete if not in another table
SELECT 1 from table
sql select all records from all tables where not empty
select true if exists on another table or false sqlserver
sql select all from one table and one column from another
sql select where id not exists in another table
sql select column name like from multiple tables
get table which have specific columns in mysql
join to find results not in another table
get record which is available in one table but not in another mysql
get rows from 1 table with other table empty mysql
sql select rows with different values in one column
sql check same row
New to Communities?
Join the community