SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE Table1 (`id` INTEGER, `Name` TEXT, `ParentIDFromTable2` INTEGER, `Weight` INTEGER, `Height` INTEGER);
✓
INSERT INTO Table1 (`id`, `Name`, `ParentIDFromTable2`, `Weight`, `Height`) VALUES
  ('1', 'Jack', '5', '180', '183'), ('2', 'Sparrow', '3', '210', '169'), ('3', 'John', '6', '350', '210'), 
  ('4', 'Jill', '2', '110', '140'), ('5', 'Juliet', '7', '122', '150');
✓
CREATE TABLE Table2 (`id` INTEGER, `Name` TEXT, `GrandParentID` INTEGER, `Location` TEXT);
✓
INSERT INTO Table2 (`id`, `Name`, `GrandParentID`, `Location`) VALUES
  ('1', 'Adam', '0', 'Earth'), ('2', 'Zack', '1', 'Earth'), ('3', 'Noah', '2', 'Earth'), ('4', 'Jacob', '3', 'Earth'),
  ('5', 'Jeff', '4', 'Earth'), ('6', 'Drake', '5', 'Earth'), ('7', 'Kanye', '3', 'Earth');
✓
WITH 
  target AS (SELECT * FROM Table1 WHERE id = 1),
  cte AS (
    SELECT *, 1 level FROM Table2 WHERE id = (SELECT ParentIDFromTable2 FROM target)
    UNION ALL
    SELECT t2.*, c.level + 1 
    FROM Table2 t2 INNER JOIN cte c
    ON c.GrandParentID = t2.id
  )
SELECT *,
      (SELECT Location || '/' || 
              GROUP_CONCAT(Name, '/') OVER (ORDER BY level DESC) FROM cte ORDER BY level LIMIT 1
      ) || '/' || Name Lineage
FROM target;


id
Name
ParentIDFromTable2
Weight
Height
Lineage


1
Jack
5
180
183
Earth/Adam/Zack/Noah/Jacob/Jeff/Jack


WITH 
  target AS (SELECT * FROM Table1 WHERE id = 5),
  cte AS (
    SELECT *, 1 level FROM Table2 WHERE id = (SELECT ParentIDFromTable2 FROM target)
    UNION ALL
    SELECT t2.*, c.level + 1 
    FROM Table2 t2 INNER JOIN cte c
    ON c.GrandParentID = t2.id
  )
SELECT *,
      (SELECT Location || '/' || 
              GROUP_CONCAT(Name, '/') OVER (ORDER BY level DESC) FROM cte ORDER BY level LIMIT 1
      ) || '/' || Name Lineage
FROM target;


id
Name
ParentIDFromTable2
Weight
Height
Lineage


5
Juliet
7
122
150
Earth/Adam/Zack/Noah/Kanye/Juliet