1 echo select t11.f5
, t13.f8 from t11
,t13 where t11.f5
=t13.f8
;
2 ---------------------------------------------------------
4 ---------------------------------------------------------
7 echo select t11.f1
,t11.f5
,t13.f8 from t11
,t13 where t11.f5
=t13.f8
;
8 ---------------------------------------------------------
10 ---------------------------------------------------------
13 echo select * from t11
,t13 where t13.f8
> t11.f5
;
14 ---------------------------------------------------------
15 t11.f1 t11.f2 t11.f3 t11.f4 t11.f5 t13.f7 t13.f8
16 ---------------------------------------------------------
19 2 Y sales
6000 20 1 50
23 echo select t11.f1
,t11.f5
,t13.f8 from t11
,t13 where t13.f8
< t11.f5
;
24 ---------------------------------------------------------
26 ---------------------------------------------------------