Adaptive Server release 12.5.1 and later supports as many as 50 user tables and 14 worktables, increased from 16 user tables and 12 worktables in 11.9.2. However, the limits on number of referential integrity checks remain at 192 and the number of subqueries allowed remains at 16.
Adaptive Server release 15.0 supports 46 worktables
in a query.
