Chris <[EMAIL PROTECTED]> writes: > Quick test: > create table a(a int primary key, b int, c varchar(200)); > insert into a(a, b, c) values (1,1,'one'); > insert into a(a, b, c) values (2,2,'two'); > insert into a(a, b, c) values (3,1,'one'); > insert into a(a, b, c) values (4,2,'two');
> mysql> select a,b,c from a group by b; > +---+------+------+ > | a | b | c | > +---+------+------+ > | 1 | 1 | one | > | 2 | 2 | two | > +---+------+------+ > 2 rows in set (0.00 sec) Egad :-(. At least the SQL spec has some notion of wanting the answer to a query to be well-defined ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly