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.