SAP Sybase IQ allows automatic joins between tables.
In addition to the NATURAL and OUTER join operators supported in other implementations, SAP Sybase IQ allows KEY joins between tables based on foreign-key relationships. This reduces the complexity of the WHERE clause when performing joins.