A general suggestion:
Try doing some other things that you're pretty sure should work, even though you don't see why they should be necessary.
For example, you could try creating a duplicate table and then try your queries again against the duplicate.
Since you say the tables aren't terribly large, you could try making multiple copies of the tables, and then do joins between different tables with identical data, instead of trying to get self-joins to work.
Mysql myiasm tables are capable of much weirdness, so don't just *assume* the problem is on your end...
And by all means, run with RaiseError on, and use "use strict"... this might flag a problem you're missing.
|