Kevin Frank has posted another blog on
For ExecuteSQL newbies, there are MANY articles on ExecuteSQL on this site. ExecuteSQL | FileMakerHacks
Specifically these are a first step to learn (get the PDF and example files, the actual blog is "phase one"!):
in Japanese, the link to that PDF is here:
Only a few changes in FM13 & 14 (the new clauses for FIRST and OFFSET), are noted here:
For writing the SQL, the listed resources have at least two 'template' databases that help you get the syntax more correct.