use Perl

• First thing I'd try (Score:1)

  by Aristotle (5147)

  SELECT i.i1, i.i2, t3.i
  FROM (
      SELECT t1.i AS i1, t2.i AS i2
      FROM t1
      INNER JOIN t2 ON t2.i = t1.i
  ) i
  RIGHT JOIN t3 ON t3.i = i.i2;

  No idea if this actually fixes the problem. Depends on what the query planner turns it into, I guess.
  • Re: (Score:2)

    by Ovid (2709)

    4.0.18 doesn't allow subqueries.
    • Re: (Score:1)

      by Aristotle (5147)

      Are you sure? ISTR using them in some 4.x version; maybe it was 4.1? Sigh.
      • Re:First thing I'd try (Score:2)

        by vek (2312) on 2007.10.08 10:41 (#58245) Journal

        They added subselects back in 2003 to version 4.1

        Reply to This

        Parent