DB2 database, table multiplication, direct expansion of table data

T1 table

SEQ Table

Want the result set to be:

Statement:

SELECT * from(SELECT *  fromseq,t1) U Left JOINT1 onU.id=T1.id andU.jjh=T1.jjh andU.num>=T1.begin_num andU.num<=T1.end_numWHERET1.id is  not NULL

Description

SEQ,T1 multiply the table set by multiplying the rows and columns.

SEQ, all rows correspond to T1, each row, altogether corresponds to the number of rows of the T1 table so many times

This multiplies the set of tables as follows:

DB2 database, table multiplication, direct expansion of table data