Show data that has no data in other tables in MySQL

Question

I want to show data where data is not in other tables.

enter image description here

Possible duplicate of [SQL - find records from one table which don't exist in another](https://stackoverflow.com/questions/367863/sql-find-records-from-one-table-which-dont-exist-in-another) — Masivuye Cokile, Jun 04 '18 at 14:27
See: [Why should I provide an MCVE for what seems to me to be a very simple SQL query?](https://meta.stackoverflow.com/questions/333952/why-should-i-provide-an-mcve-for-what-seems-to-me-to-be-a-very-simple-sql-query) — Strawberry, Jun 04 '18 at 14:28
This is not a PHP, nor mysqli question. Look at `join`s with `mysql`. — user3783243, Jun 04 '18 at 14:28

score -1 · Accepted Answer · answered Jun 04 '18 at 14:30

-1

Use a sub query.

SELECT a.* 
FROM tabel_a a
WHERE a.id NOT IN (SELECT b.id FROM tabel_b b)

Output

id  name
1   aa
2   bb

answered Jun 04 '18 at 14:30

Matt

Better is to use `a LEFT JOIN b ... WHERE b.column IS NULL` @A.Colonna Because `NOT EXISTS` requires a co-related subquery.. – Raymond Nijland Jun 04 '18 at 15:24
it seems to me If there is no key on id NOT EXISTS is faster – A. Colonna Jun 04 '18 at 15:34

1 Answers1