SELECT left.name, right.name FROM people AS left INNER JOIN people AS right WHERE left.name > right.name;
what do you actually see? When a query like this returns an unexpected result, what do you draw as you trace through its execution, and why? It'll be a few weeks before Zuzel can start her study (we need to get ethics clearance first), but she'd welcome your thoughts.
comments powered by Disqus