test/sql/Join/exp.test004.ksh

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