test/sql/Join/exp.test009.ksh

   1 echo select t11.f5, t13.f8 from t11,t13 where t11.f5=t13.f8;
   2 ---------------------------------------------------------
   3         t11.f5  t13.f8
   4 ---------------------------------------------------------
   5         20      20
   6
   7 echo select t11.f1,t11.f5,t13.f8 from t11,t13 where t11.f5=t13.f8;
   8 ---------------------------------------------------------
   9         t11.f1  t11.f5  t13.f8
  10 ---------------------------------------------------------
  11         2       20      20
  12
  13 echo select * from t11,t13 where t13.f8 > t11.f5;
  14 ---------------------------------------------------------
  15         t11.f1  t11.f2  t11.f3  t11.f4  t11.f5  t13.f7  t13.f8
  16 ---------------------------------------------------------
  17         1       X       IT      5000    10      2       20
  18         1       X       IT      5000    10      1       50
  19         2       Y       sales   6000    20      1       50
  20         3       Z       IT      7000    10      2       20
  21         3       Z       IT      7000    10      1       50
  22
  23 echo select t11.f1,t11.f5,t13.f8 from t11,t13 where t13.f8 < t11.f5;
  24 ---------------------------------------------------------
  25         t11.f1  t11.f5  t13.f8
  26 ---------------------------------------------------------
  27