That's not a link that solve this problem.
I just want to implement the logic.
I have the solution in SQL Query but in FileMaker, the commands are different
and I'm not familiar.
If you know how to solve it, please give me the solution/the codes.
Knowlegde supposed to be shared. Isn't it?
<shrug> I gave you my best advice. You are free to take it or ignore it - but please don't lecture me. If I choose to share my knowledge with you, it's my courtesy, not your right.
Speaking of courtesy, I have only now noticed that the thread I have linked to is also yours. Which means I have wasted my time reading your question again, looking for my previous answer, and posting it here.