Cross-table join functions

Under the new mechanism, you can only use the following functions in your query:

It is highly recommended that you restrict queries to run only on indexed fields. Running these queries on non-indexed fields can result in poor performance.