SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE wz(
   nr    VARCHAR(2) NOT NULL
  ,id    VARCHAR(3) NOT NULL
  ,ilosc int
);
INSERT INTO wz(nr,id,ilosc) VALUES ('d1','id1','1');
INSERT INTO wz(nr,id,ilosc) VALUES ('d1','id2','2');
INSERT INTO wz(nr,id,ilosc) VALUES ('d2','id3','3');
INSERT INTO wz(nr,id,ilosc) VALUES ('d2','id4','4');
INSERT INTO wz(nr,id,ilosc) VALUES ('d3','id1','5');
INSERT INTO wz(nr,id,ilosc) VALUES ('d4','id5','6');
INSERT INTO wz(nr,id,ilosc) VALUES ('d4','id2','7');
INSERT INTO wz(nr,id,ilosc) VALUES ('d4','id3','8');
8 rows affected

CREATE TABLE pz(
   nr    VARCHAR(3) NOT NULL
  ,id    VARCHAR(3) NOT NULL
  ,ilosc int
);
INSERT INTO pz(nr,id,ilosc) VALUES ('pz1','id1','2');
INSERT INTO pz(nr,id,ilosc) VALUES ('pz1','id2','1');
INSERT INTO pz(nr,id,ilosc) VALUES ('d2','id3','3');
INSERT INTO pz(nr,id,ilosc) VALUES ('d2','id4','4');
INSERT INTO pz(nr,id,ilosc) VALUES ('d3','id1','5');
INSERT INTO pz(nr,id,ilosc) VALUES ('d4','id5','6');
INSERT INTO pz(nr,id,ilosc) VALUES ('d4','id2','7');
INSERT INTO pz(nr,id,ilosc) VALUES ('d4','id3','8');
8 rows affected

with wzc as (select 
  nr
  , string_agg(id,';') WITHIN GROUP (ORDER BY id ASC) AS id
  ,sum(ilosc) il 
from 
  wz 
group by 
  nr)
, pzc as (select 
  nr
  , string_agg(id,';') WITHIN GROUP (ORDER BY id ASC) AS id
  ,sum(ilosc) il 
from 
  pz
group by 
  nr)
, dok as (
  select 
      wzc.nr as wz
      ,pzc.nr as pz
  from
      wzc
      inner join pzc on pzc.il=wzc.il and pzc.id=wzc.id
  )

select * from dok


wz
pz


d2
d2

d3
d3

d4
d4

d1
pz1


with wzc as (select 
  nr
  , string_agg(concat(id,'|',ilosc),';') WITHIN GROUP (ORDER BY id ASC) AS id
  ,sum(ilosc) il 
from 
  wz 
group by 
  nr)
, pzc as (select 
  nr
  , string_agg(concat(id,'|',ilosc),';') WITHIN GROUP (ORDER BY id ASC) AS id
  ,sum(ilosc) il 
from 
  pz
group by 
  nr)
, dok as (
  select 
      wzc.nr as wz
      ,pzc.nr as pz
  from
      wzc
      inner join pzc on pzc.id=wzc.id
  )

select * from dok



wz
pz


d2
d2

d3
d3

d4
d4