AvocadoDB Query Language - Jan Steemann

© 2012 triAGENS GmbH | 2012-04-04 22 FOR: List iteration  Nesting of multiple FOR blocks is possible  Example: cross product of users and locations (u x l): FOR u IN users FOR l IN locations  A result document containing both variables (u, l) is produced on each iteration of the inner loop  The result document contains both u and l  Note: this is equivalent to the following SQL queries: SELECT * FROM users u, locations l SELECT * FROM users u INNER JOIN locations l ON (1=1)