AnsweredAssumed Answered

Help with ExecuteSQL

Question asked by KylePutzier on Jan 23, 2017
Latest reply on Jan 24, 2017 by beverly

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.