The Advanced Search Tool supports adding fields from multiple tables. The resulting code is specific to MinistryPlatform, so it is not covered in this article. The tool uses the Table Lookup Convention which in SQL is the JOIN clause.

See Also:

• Table Lookup Convention: A method looking up fields in related tables specific to MinistryPlatform.
• Intermediate SQL: ORDER BY, NULL, AND vs. OR, dynamic dates.
• Advanced SQL: Joins, Table Aliases, and more.