By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE IF NOT EXISTS "A" ("A1" INTEGER, "A2" TEXT);
INSERT INTO "A" ("A1","A2") VALUES
(1,'/a/l/m/'),
(2,'/b/x/s/'),
(3,'/aa/e/t/'),
(4,'/d/q/z/');
CREATE TABLE IF NOT EXISTS "B" ("B1" INTEGER, "B2" TEXT);
INSERT INTO "B" ("B1","B2") VALUES
(1,'a'),
(1,'q'),
(1,'z'),
(2,'s'),
(2,'t'),
(3,'n');
SELECT DISTINCT A1
FROM A INNER JOIN B
ON A.A2 LIKE '%' || B.B2 || '%'
WHERE B.B1 = 1;
| A1 |
|---|
| 1 |
| 3 |
| 4 |