6 Replies Latest reply on Jan 24, 2017 5:07 AM by beverly

    Help with ExecuteSQL


      Can someone please help me write the SQL formula to do this:


      Return the sum of ChildTable::MyNumberField


      (ParentTable::MyID matches ChildTable::MyID


      ChildTable:MyTextField contains “MyString”)


      That's the best way I could represent what I need to do.

      I could easily do this using native FMP relations, but I don't what to make a new relationship (and parent key for the “MyString” part) for just 1 calculation. And, It's about time I learn SQL queries.