test/sql/Join/exp.test008.ksh

   1 echo  select * from t11,t12 where t11.f5=t12.f1;
   2 ---------------------------------------------------------
   3         t11.f1  t11.f2  t11.f3  t11.f4  t11.f5  t12.f1  t12.f2  t12.f3
   4 ---------------------------------------------------------
   5         1       X       IT      5000    10      10      IT      BBSR
   6         2       Y       sales   6000    20      20      HR      CTC
   7         3       Z       IT      7000    10      10      IT      BBSR
   8
   9 echo  select * from t11,t12 where t11.f5 > t12.f1;
  10 ---------------------------------------------------------
  11         t11.f1  t11.f2  t11.f3  t11.f4  t11.f5  t12.f1  t12.f2  t12.f3
  12 ---------------------------------------------------------
  13         2       Y       sales   6000    20      10      IT      BBSR
  14
  15 echo select * from t11,t12 where t12.f1 <= t11.f5;
  16 ---------------------------------------------------------
  17         t11.f1  t11.f2  t11.f3  t11.f4  t11.f5  t12.f1  t12.f2  t12.f3
  18 ---------------------------------------------------------
  19         1       X       IT      5000    10      10      IT      BBSR
  20         2       Y       sales   6000    20      10      IT      BBSR
  21         2       Y       sales   6000    20      20      HR      CTC
  22         3       Z       IT      7000    10      10      IT      BBSR
  23
  24 echo select * from t11,t12 where t12.f1 != t11.f5;
  25 ---------------------------------------------------------
  26         t11.f1  t11.f2  t11.f3  t11.f4  t11.f5  t12.f1  t12.f2  t12.f3
  27 ---------------------------------------------------------
  28         1       X       IT      5000    10      20      HR      CTC
  29         1       X       IT      5000    10      30      R&D     DELHI
  30         2       Y       sales   6000    20      10      IT      BBSR
  31         2       Y       sales   6000    20      30      R&D     DELHI
  32         3       Z       IT      7000    10      20      HR      CTC
  33         3       Z       IT      7000    10      30      R&D     DELHI
  34
  35 echo select * from t11,t12 where t12.f1 > 20;
  36 ---------------------------------------------------------
  37         t11.f1  t11.f2  t11.f3  t11.f4  t11.f5  t12.f1  t12.f2  t12.f3
  38 ---------------------------------------------------------
  39         1       X       IT      5000    10      30      R&D     DELHI
  40         2       Y       sales   6000    20      30      R&D     DELHI
  41         3       Z       IT      7000    10      30      R&D     DELHI
  42