2 echo select t1.f2
, t1.f1
, t2.f1 from t1
,t2
;
3 ---------------------------------------------------------
5 ---------------------------------------------------------
32 echo select t1.f2
, t1.f1
, t2.f1 from t1
,t2 group by t1.f2
;
33 Statement prepare failed with error
-19
34 echo select t1.f2
, max
(t1.f1
), sum(t2.f1
) from t1
, t2 group by t1.f2
;
35 ---------------------------------------------------------
36 t1.f2 MAX
(t1.f1
) SUM
(t2.f1
)
37 ---------------------------------------------------------
44 echo select f1
, f2 from t1 group by f1
,f2
;
45 ---------------------------------------------------------
47 ---------------------------------------------------------
54 echo select f1
, sum(f2
) from t1 group by f3
;
55 Statement prepare failed with error
-19