Db2 11.1

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

-- create table_1
CREATE TABLE TABLE_1 (ID, ITEM_1, Appliction) AS 
(
VALUES 
  (1, 'item1', 'read')
, (2, 'item2', 'write')
, (3, 'item3', 'learn')
) WITH DATA
-- create table_2
CREATE TABLE TABLE_2 (ID, ITEM_2, Description, STATUS) AS 
(
VALUES 
  (10, 'item1', 'des1', 0)
, (11, 'item1', 'des2', 0)
, (12, 'item1', 'des3', 2)
) WITH DATA
WITH U AS 
(SELECT COUNT (1) AS DUMMY FROM NEW TABLE
  (UPDATE TABLE_2 A SET STATUS = 9 WHERE EXISTS 
    (SELECT 1 FROM TABLE_2 B WHERE B.ITEM_2 = A.ITEM_2 AND A.ID > B.ID AND A.STATUS = 0
    )))
select T1.ID, T1.ITEM_1, T1.Appliction, T2.ID, T2.ITEM_2, T2.Description, T2.STATUS 
  from TABLE_1 T1
Inner join TABLE_2 T2 ON  T1.ITEM_1 = T2.ITEM_2
where T2.STATUS = 0


ID
ITEM_1
APPLICTION
ID
ITEM_2
DESCRIPTION
STATUS


1
item1
read
10
item1
des1
0