SUMMARY: ANSI JOIN provides much more flexibility in join operations in Couchbase N1QL, compared to previously supported lookup join and index join. The examples above show various ways you can use ANSI JOIN in queries. Since ANSI JOIN is widely used in the relational world, the support for ANSI JOIN in Couchbase N1QL should make it much easier to migrate applications from a relational database to Couchbase N1QL.