Hi FileMaker community!
So I am getting unexpected results from an ExecuteSQL query and I hope you can find my mistake.
I am attaching a link to the issue description (screen recording) on SQL Issue - YouTube , and the file in question as well.
FileMaker Pro Server 15 on MacPro System ElCapitan (10.11.6)
FileMaker Pro Advanced 15 on MacBook Pro Sierra (10.12.1)
Philip (Judd) Jaffe