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

    Help with ExecuteSQL

    KylePutzier

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

       

      Return the sum of ChildTable::MyNumberField

      when

      (ParentTable::MyID matches ChildTable::MyID

      and

      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.

       

      Kyle