SELECT *
  FROM z1 AS a
   JOIN zz2 AS b ON a.z1 = b.z11 AND b.z22 LIKE concat(a.z2, '%');


z1          z2          z11         z22
----------- ----------- ----------- -----------
1           1           1           111
1           2           1           222
1           3           1           333
1           4           1           444
2           22          2           2222
2           22          2           2232
2           22          2           2242
3           33          3           3331
3           33          3           3332

WITH A
     AS (SELECT *, 
                DENSE_RANK() OVER(ORDER BY z1) AS dr, 
                ROW_NUMBER() OVER(PARTITION BY z1 ORDER BY z2) AS rn
           FROM z1),
     B
     AS (SELECT *, 
                DENSE_RANK() OVER(ORDER BY z11) AS dr, 
                ROW_NUMBER() OVER(PARTITION BY z11 ORDER BY z22) AS rn
           FROM zz2)
     SELECT a.z1, 
            a.z2, 
            b.z11, 
            b.z22
       FROM a
            OUTER APPLY
     (
         SELECT TOP 1 *
           FROM b
          WHERE a.z1 = b.z11
                AND b.dr = a.dr
                AND b.rn >= a.rn
     ) AS b
      WHERE b.rn IS NOT NULL;




z1          z2          z11         z22
----------- ----------- ----------- -----------
1           1           1           111
1           2           1           222
1           3           1           333
1           4           1           444
2           22          2           2222
2           23          2           2232
2           24          2           2242
3           33          3           3331
3           34          3           3332

ORDER BY b.dr, b.rn