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.

In reply to Re^3: DBI and MySQL issue by doom
in thread DBI and MySQL issue by tbone1

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.