> The "problem" is to produce 3 rows where, relationally, the only answers have > 2 or 4 rows. There is no right answer to the problem because there is no > answer to the problem.
Which is what I said. The solution with 3 rows is unambiguous. You either resolve this the way the standard does by making it "implementation defined" or by forcing the query to be unambiguous by adding all the ORDER BY columns to the SELECT list. Regards David M Bennett FACS Andl - A New Database Language - andl.org