test/sql/Join/exp.test010.ksh

   1 echo select * from t11,t12,t13 where t12.f1=t13.f8 and t13.f7=t11.f1;
   2 ---------------------------------------------------------
   3         t11.f1  t11.f2  t11.f3  t11.f4  t11.f5  t12.f1  t12.f2  t12.f3  t13.f7  t13.f8
   4 ---------------------------------------------------------
   5         2       Y       sales   6000    20      20      HR      CTC     2       20
   6
   7 echo select * from t11,t12,t13 where t12.f1=t13.f8 or t13.f7=t11.f1;
   8 ---------------------------------------------------------
   9         t11.f1  t11.f2  t11.f3  t11.f4  t11.f5  t12.f1  t12.f2  t12.f3  t13.f7  t13.f8
  10 ---------------------------------------------------------
  11         1       X       IT      5000    10      10      IT      BBSR    1       50
  12         1       X       IT      5000    10      20      HR      CTC     2       20
  13         1       X       IT      5000    10      20      HR      CTC     1       50
  14         1       X       IT      5000    10      30      R&D     DELHI   1       50
  15         2       Y       sales   6000    20      10      IT      BBSR    2       20
  16         2       Y       sales   6000    20      20      HR      CTC     2       20
  17         2       Y       sales   6000    20      30      R&D     DELHI   2       20
  18         3       Z       IT      7000    10      20      HR      CTC     2       20
  19