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 |