SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE table1
    ("Person" INTEGER, "Package ID" TEXT(4), "Date" TEXT(10))
;

✓
INSERT INTO table1
    ("Person", "Package ID", "Date")
VALUES
    (1, 'Y788', '01-01-2020')
;

✓
INSERT INTO table1
    ("Person", "Package ID", "Date")
VALUES
    (2, 'T932', '01-02-2020')
;
✓
INSERT INTO table1
    ("Person", "Package ID", "Date")
VALUES
    (3, 'W345', '01-03-2020')
;
✓
INSERT INTO table1
    ("Person", "Package ID", "Date")
VALUES
    (3, 'S122', '01-03-2020')
;

✓
INSERT INTO table1
    ("Person", "Package ID", "Date")
VALUES
    (4, 'F567', '01-04-2020')
;

✓
INSERT INTO table1
    ("Person", "Package ID", "Date")
VALUES
    (4, 'H767', '01-04-2020')
;
✓
CREATE TABLE table2
    ("Person" INTEGER, "Package ID" TEXT(10), "Date" TEXT(10))
;

✓
INSERT INTO table2
    ("Person", "Package ID", "Date")
VALUES
    (1, 'Y788', '01-01-2020')
;

✓
INSERT INTO table2
    ("Person", "Package ID", "Date")
VALUES
    (2, 'T932', '01-02-2020')
;

✓
INSERT INTO table2
    ("Person", "Package ID", "Date")
VALUES
    (3, 'W345,S122', '01-03-2020')
;

✓
INSERT INTO table2
    ("Person", "Package ID", "Date")
VALUES
    (4, 'F567,H767', '01-04-2020')
;

✓
INSERT INTO table2
    ("Person", "Package ID", "Date")
VALUES
    (5, 'C555', '01-05-2020')
;
✓
SELECT table2."Person", table2."Package ID", table2."Date"  
FROM table2 LEFT JOIN table1 ON  table1."Person" = table2."Person"
WHERE  (',' || table2."Package ID" || ',') NOT LIKE ('%,' || COALESCE(table1."Package ID",'') || ',%')


Person
Package ID
Date


5
C555
01-05-2020