test/sql/Join/exp.test013.ksh

   1 select * from t11,t12,t13 where t12.f1=t13.f8 and t13.f7=t11.f1;
   2 ---------------------------------------------------------
   3         f1      f2      f3      f4      f5      f1      f2      f3      f7      f8
   4 ---------------------------------------------------------
   5         2       Y       sales   6000    20      20      HR      CTC     2       20
   6
   7  select * from t11,t12,t13 where t12.f1=t13.f8 or t13.f7=t11.f1;
   8 ---------------------------------------------------------
   9         f1      f2      f3      f4      f5      f1      f2      f3      f7      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