test/jdbc/Statement/exp.test022.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,T2;
  19 T1.f1   T2.f1   T1.f2   T2.f2   T1.f3   T2.f3
  20 0       0       1       1       2       2
  21 0       2       1       3       2       4
  22 0       4       1       5       2       6
  23 0       6       1       7       2       8
  24 0       8       1       9       2       10
  25 1       0       2       1       3       2
  26 1       2       2       3       3       4
  27 1       4       2       5       3       6
  28 1       6       2       7       3       8
  29 1       8       2       9       3       10
  30 2       0       3       1       4       2
  31 2       2       3       3       4       4
  32 2       4       3       5       4       6
  33 2       6       3       7       4       8
  34 2       8       3       9       4       10
  35 3       0       4       1       5       2
  36 3       2       4       3       5       4
  37 3       4       4       5       5       6
  38 3       6       4       7       5       8
  39 3       8       4       9       5       10
  40 4       0       5       1       6       2
  41 4       2       5       3       6       4
  42 4       4       5       5       6       6
  43 4       6       5       7       6       8
  44 4       8       5       9       6       10
  45 5       0       6       1       7       2
  46 5       2       6       3       7       4
  47 5       4       6       5       7       6
  48 5       6       6       7       7       8
  49 5       8       6       9       7       10
  50 6       0       7       1       8       2
  51 6       2       7       3       8       4
  52 6       4       7       5       8       6
  53 6       6       7       7       8       8
  54 6       8       7       9       8       10
  55 7       0       8       1       9       2
  56 7       2       8       3       9       4
  57 7       4       8       5       9       6
  58 7       6       8       7       9       8
  59 7       8       8       9       9       10
  60 8       0       9       1       10      2
  61 8       2       9       3       10      4
  62 8       4       9       5       10      6
  63 8       6       9       7       10      8
  64 8       8       9       9       10      10
  65 9       0       10      1       11      2
  66 9       2       10      3       11      4
  67 9       4       10      5       11      6
  68 9       6       10      7       11      8
  69 9       8       10      9       11      10
  70 SELECT T1.f1,T2.f1,T1.f2,T2.f2,T1.f3,T2.f3 FROM T1,T2 WHERE T1.f1>=2 AND T1.f2>=4 AND T2.f3=6
  71 T1.f1   T2.f1   T1.f2   T2.f2   T1.f3   T2.f3
  72 3       4       4       5       5       6
  73 4       4       5       5       6       6
  74 5       4       6       5       7       6
  75 6       4       7       5       8       6
  76 7       4       8       5       9       6
  77 8       4       9       5       10      6
  78 9       4       10      5       11      6