A Sybase IQ server may have several local databases running at one time. By defining tables in other local Sybase IQ databases as remote tables, you can perform cross-database joins.
See SQL Anywhere Server - SQL Usage > Remote data and bulk operations > Accessing remote data > Join tables from multiple local databases.