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

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

Outcomes