use Perl

• what about LEFT? (Score:1)

  by perrin (4270)

  Clearly the best solution is to upgrade to a recent version. 5.0 has been the stable release for years and has many improvements over older versions.
  
  Failing that, isn't a RIGHT JOIN just a LEFT JOIN with the table order reversed? If you list the tables in reverse order and use a LEFT JOIN will it work?
  • Re: (Score:2)

    by Ovid (2709)

    No, because reversing the order gives you this:

    select t1.i, t2.i, t3.i
    from t3
    left  join t2 on t3.i = t2.i
    inner join t1 on t1.i = t2.i;

    That final INNER JOIN excludes the NULL row we need.
    • Re: (Score:1)

      by perrin (4270)

      In that case, the simplest fix is probably a temp table, used in the same way you would use a subquery in a more recent version.
      • Re: (Score:1)

        by Aristotle (5147)

        How… relational.
        • Re: (Score:1)

          by perrin (4270)

          It seems a bit unfair to criticize MySQL for something that was literally fixed years ago. The 4.0 series isn't even supported anymore.
          • Re: (Score:1)

            by Aristotle (5147)

            Huh, that was a criticism of MySQL?
            • Re:what about LEFT? (Score:1)

              by perrin (4270) on 2007.10.09 20:36 (#58267) Journal

              It sounded that way. Apologies if I read too much into it. Sarcasm is a tough call sometimes on message boards.

              Reply to This

              Parent

              • Re: (Score:1)

                by Aristotle (5147)

                It just struck me as funny after reading the posts Ovid recently wrote about real relational databases, noting among other things that a select query there returns a bonafide table.