The parameter list of a table procedure can reference columns from tables in the FROM clause or result columns of another table procedure in the FROM clause. This effectively represents a join between the tables and table procedures with one set of result rows being produced by the table procedure for each set of column values referenced in its parameter list. However, if parameter lists of table procedures reference result columns of other table procedures, they must not form a cycle.

For example, the following is not permitted

because the tproc1 parameter list references a result column of tproc2 and the tproc2 parameter list references a result column from tproc1.