© 2012 triAGENS GmbH | 2012-04-04 28 FILTER: results filtering That means: in AvocadoDB you would use FILTER FOR u IN users FOR l IN locations FILTER u.a == l.b whereas in SQL you would use either ON SELECT * FROM users (INNER) JOIN locations l ON u.a == l.b or WHERE: SELECT * FROM users, locations l WHERE u.a == l.b