test/sql/Join/exp.test005.ksh

   1 echo select t1.f1,t2.f1,t3.f1 from t1,t2,t3 where t1.f2=t2.f2 or t1.f1 > 100;
   2 ---------------------------------------------------------
   3         t1.f1   t2.f1   t3.f1
   4 ---------------------------------------------------------
   5         98      98      98
   6         98      98      100
   7         98      98      102
   8         99      99      98
   9         99      99      100
  10         99      99      102
  11         100     100     98
  12         100     100     100
  13         100     100     102
  14
  15 echo select t1.f1, t2.f1, t3.f1 from t1,t2,t3 where t1.f2= t2.f2 and t1.f3 = t3.f2;
  16 ---------------------------------------------------------
  17         t1.f1   t2.f1   t3.f1
  18 ---------------------------------------------------------
  19         99      99      100
  20         100     100     100
  21