Re: Showing recordsets from tables with one (main table) to many (secondary table) relationship

[Rick James]

Given fields a,b,c.
You want to ORDER BY a,b,c
And you want to "pick up where you left off", which is at $a, $b, $c.
You want to start with the one _after_ ($a, $b, $c)

WHERE  a >= $a
  AND ( a > $a OR
       (a = $a
           AND   b >= $b
           AND  ( b > $b OR
                 (b = $b
                     AND  c > $c
      ))        ))
ORDER BY a,b,c

Note that 'b' code is essentially the same as 'a'. 'c' code is the last one, so it is simpler.

It won't be very efficient (because of all the ORs). But it does get one test (a >= $a) in before going inefficient.