400
400
insert into t2 values (1,3),(3,1),(2,2),(1,1);
401
401
select t1.a,t2.b from t1,t2 where t1.a=t2.a group by t1.a,t2.b;
402
402
select t1.a,t2.b from t1,t2 where t1.a=t2.a group by t1.a,t2.b ORDER BY NULL;
403
404
explain select t1.a,t2.b from t1,t2 where t1.a=t2.a group by t1.a,t2.b;
404
406
explain select t1.a,t2.b from t1,t2 where t1.a=t2.a group by t1.a,t2.b ORDER BY NULL;