SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE people (`Name` TEXT, `Age` INTEGER);
✓
INSERT INTO people (`Name`, `Age`) VALUES
  ('Jane', '50'),
  ('John', '80'),
  ('Alice', '46'),
  ('Mark', '25'),
  ('Harry', '33');
✓
CREATE TABLE work (`Name` TEXT, `work_id` INTEGER);
✓
INSERT INTO work (`Name`, `work_id`) VALUES
  ('Jane', '1'),
  ('Amanda', '2'),
  ('Filip', '3'),
  ('Alice', '4'),
  ('Jack', '5'),
  ('Harry', '6');
✓
SELECT w.work_id,
       p.Age
FROM work AS w INNER JOIN people AS p
ON p.Name = w.Name;


work_id
Age


1
50

4
46

6
33


SELECT *
FROM work
WHERE Name NOT IN (SELECT Name FROM people);


Name
work_id


Amanda
2

Filip
3

Jack
5