1 echo select * from t1
,t2 where t1.f1
>100 or t2.f1
<100;
2 ---------------------------------------------------------
3 t1.f1 t1.f2 t1.f3 t2.f1 t2.f2 t2.f3
4 ---------------------------------------------------------
30 echo select * from t1
,t2 where t1.f1
= t2.f1 and t1.f1
>100;
31 ---------------------------------------------------------
32 t1.f1 t1.f2 t1.f3 t2.f1 t2.f2 t2.f3
33 ---------------------------------------------------------