AvocadoDB Query Language - Jan Steemann

© 2012 triAGENS GmbH | 2012-04-04 25 FILTER: results filtering  The FILTER keyword in combination with nested FOR blocks can be used to perform joins  Example: retrieve all users that have matching locations FOR u IN users FOR l IN locations FILTER u.a == l.b  Note: this is equivalent to the following SQL queries: SELECT * FROM users u, locations l WHERE u.a == l.b SELECT * FROM users u (INNER) JOIN locations l ON u.a == l.b Access to the individual list elements using variable names