-
Multi Join FileMaker ExecuteSQL Query
I have a client with a database that was over engineered. Rather build a set of overly complex relationships to find this data I attempted my first multi inner join query with SQL. The result was highly successful! Greatly reducing the speeding on reporting pages. The query finds country names, groups them by name, and sums the days the user is in country.
-
Missing FileMaker ExecuteSQL Documentation
https://filemakerhacks.com/2012/10/19/the-missing-fm-12-executesql-reference/ Very useful article!