/SQL/Select from one table where not on the other

Select from one table where not on the other

Select from one table where not on the other

SELECT id FROM a.table
WHERE id NOT IN (SELECT b.id FROM b.id)

1

Source: stackoverflow.com

Similar codes

0 vote315 views1 answer
Do you know sql
SQL
0 vote305 views2 answers
Sql searching via key word
SQL
0 vote310 views1 answer
Vowels in sql
SQL
0 vote311 views1 answer
How to reset table in sql server
SQL
12 votes299 views4 answers
Install mysql ubuntu 18.04
SQL
0 vote343 views1 answer
Check if mysql db is used
SQL
1 vote311 views1 answer
Rename table column name in mysql
SQL
3 votes424 views1 answer
How to get yesterday date in sql
SQL
0 vote310 views1 answer
Tsql pad left
SQL
13 votes299 views4 answers
Mysql select last 10 rows
SQL

Share