You begin an ANSI join with the [LEFT] [OUTER] JOIN keywords, use the ON clause to specify the join filter, and use the WHERE clause to specify a post-join filter.
| Task | Manual |
|---|---|
| Use the ANSI join syntax. | IBM Informix Guide to SQL: Syntax |
| Use join filters and post-join filters, and interpret SET EXPLAIN output for ANSI joins. | IBM Informix Performance Guide |