例如，使用row_number窗口函数，您可以导出要连接的行号

with 
cte1 as
(select S_NO,FRUIT_BOX,ROW_NUMBER() OVER (PARTITION BY S_NO ORDER BY FRUITS) RN,
    FRUITS
 FROM T1
 LEFT JOIN T2 ON T2.FRUIT_BOX = T1.BOX
),
cte2 as
(select S_NO,VEGETABLES_BOX,ROW_NUMBER() OVER (PARTITION BY S_NO ORDER BY VEGETABLES) RN,
  VEGETABLES
 FROM T1
 LEFT JOIN T3 ON T3.VEGETABLES_BOX = T1.BOX
),
cte3 as
(SELECT s_no,RN FROM CTE1 union select s_no,rn from cte2)

select cte3.s_no,t1.box,
         cte1.fruits,
         cte2.vegetables 
from cte3
left join cte1 on cte3.s_no = cte1.s_no and cte3.rn = cte1.rn
left join cte2 on cte3.s_no = cte2.s_no and cte3.rn = cte2.rn
left join t1 on t1.s_no = cte3.s_no;