test/jdbc/Statement/exp.test023.ksh

   1 SELECT * FROM T1;
   2 Tuple value is 0 1 2 0 1000.0 Nihar0 2008-03-21 18:00:00 2008-03-21 18:00:00.0
   3 Tuple value is 1 2 3 1 1001.0 Nihar1 2008-03-21 18:00:00 2008-03-21 18:00:00.0
   4 Tuple value is 2 3 4 2 1002.0 Nihar2 2008-03-21 18:00:00 2008-03-21 18:00:00.0
   5 Tuple value is 3 4 5 3 1003.0 Nihar3 2008-03-21 18:00:00 2008-03-21 18:00:00.0
   6 Tuple value is 4 5 6 4 1004.0 Nihar4 2008-03-21 18:00:00 2008-03-21 18:00:00.0
   7 Tuple value is 5 6 7 5 1005.0 Nihar5 2008-03-21 18:00:00 2008-03-21 18:00:00.0
   8 Tuple value is 6 7 8 6 1006.0 Nihar6 2008-03-21 18:00:00 2008-03-21 18:00:00.0
   9 Tuple value is 7 8 9 7 1007.0 Nihar7 2008-03-21 18:00:00 2008-03-21 18:00:00.0
  10 Tuple value is 8 9 10 8 1008.0 Nihar8 2008-03-21 18:00:00 2008-03-21 18:00:00.0
  11 Tuple value is 9 10 11 9 1009.0 Nihar9 2008-03-21 18:00:00 2008-03-21 18:00:00.0
  12 SELECT * FROM T2;
  13 Tuple value is 0 1 2 0 1000.0 Nihar0 2008-03-21 18:00:00 2008-03-21 18:00:00.0
  14 Tuple value is 2 3 4 2 1002.0 Nihar2 2008-03-21 18:00:00 2008-03-21 18:00:00.0
  15 Tuple value is 4 5 6 4 1004.0 Nihar4 2008-03-21 18:00:00 2008-03-21 18:00:00.0
  16 Tuple value is 6 7 8 6 1006.0 Nihar6 2008-03-21 18:00:00 2008-03-21 18:00:00.0
  17 Tuple value is 8 9 10 8 1008.0 Nihar8 2008-03-21 18:00:00 2008-03-21 18:00:00.0
  18 SELECT T1.f1,T2.f1,T1.f2,T2.f2,T1.f3,T2.f3 FROM T1 INNER JOIN T2 ON T1.f1>=2 AND T1.f2>=4 AND T2.f3=6
  19 T1.f1   T2.f1   T1.f2   T2.f2   T1.f3   T2.f3
  20 3       4       4       5       5       6
  21 4       4       5       5       6       6
  22 5       4       6       5       7       6
  23 6       4       7       5       8       6
  24 7       4       8       5       9       6
  25 8       4       9       5       10      6
  26 9       4       10      5       11      6