join.out

PostgreSQL7.4.6 for Linux

     |   | -5 | null
     |   |    | null
     |   |    | null
     |   |  0 | null
     |   | -1 | zero
     |   |  2 | zero
     |   | -3 | zero
     |   |  4 | zero
     |   | -5 | zero
     |   | -5 | zero
     |   |    | zero
     |   |    | zero
     |   |  0 | zero
(99 rows)

SELECT '' AS "xxx", ii, tt, kk
  FROM (J1_TBL CROSS JOIN J2_TBL)
    AS tx (ii, jj, tt, ii2, kk);
 xxx | ii |  tt   | kk 
-----+----+-------+----
     |  1 | one   | -1
     |  1 | one   |  2
     |  1 | one   | -3
     |  1 | one   |  4
     |  1 | one   | -5
     |  1 | one   | -5
     |  1 | one   |   
     |  1 | one   |   
     |  1 | one   |  0
     |  2 | two   | -1
     |  2 | two   |  2
     |  2 | two   | -3
     |  2 | two   |  4
     |  2 | two   | -5
     |  2 | two   | -5
     |  2 | two   |   
     |  2 | two   |   
     |  2 | two   |  0
     |  3 | three | -1
     |  3 | three |  2
     |  3 | three | -3
     |  3 | three |  4
     |  3 | three | -5
     |  3 | three | -5
     |  3 | three |   
     |  3 | three |   
     |  3 | three |  0
     |  4 | four  | -1
     |  4 | four  |  2
     |  4 | four  | -3
     |  4 | four  |  4
     |  4 | four  | -5
     |  4 | four  | -5
     |  4 | four  |   
     |  4 | four  |   
     |  4 | four  |  0
     |  5 | five  | -1
     |  5 | five  |  2
     |  5 | five  | -3
     |  5 | five  |  4
     |  5 | five  | -5
     |  5 | five  | -5
     |  5 | five  |   
     |  5 | five  |   
     |  5 | five  |  0
     |  6 | six   | -1
     |  6 | six   |  2
     |  6 | six   | -3
     |  6 | six   |  4
     |  6 | six   | -5
     |  6 | six   | -5
     |  6 | six   |   
     |  6 | six   |   
     |  6 | six   |  0
     |  7 | seven | -1
     |  7 | seven |  2
     |  7 | seven | -3
     |  7 | seven |  4
     |  7 | seven | -5
     |  7 | seven | -5
     |  7 | seven |   
     |  7 | seven |   
     |  7 | seven |  0
     |  8 | eight | -1
     |  8 | eight |  2
     |  8 | eight | -3
     |  8 | eight |  4
     |  8 | eight | -5
     |  8 | eight | -5
     |  8 | eight |   
     |  8 | eight |   
     |  8 | eight |  0
     |  0 | zero  | -1
     |  0 | zero  |  2
     |  0 | zero  | -3
     |  0 | zero  |  4
     |  0 | zero  | -5
     |  0 | zero  | -5
     |  0 | zero  |   
     |  0 | zero  |   
     |  0 | zero  |  0
     |    | null  | -1
     |    | null  |  2
     |    | null  | -3
     |    | null  |  4
     |    | null  | -5
     |    | null  | -5
     |    | null  |   
     |    | null  |   
     |    | null  |  0
     |    | zero  | -1
     |    | zero  |  2
     |    | zero  | -3
     |    | zero  |  4
     |    | zero  | -5
     |    | zero  | -5
     |    | zero  |   
     |    | zero  |   
     |    | zero  |  0
(99 rows)

SELECT '' AS "xxx", tx.ii, tx.jj, tx.kk
  FROM (J1_TBL t1 (a, b, c) CROSS JOIN J2_TBL t2 (d, e))
    AS tx (ii, jj, tt, ii2, kk);
 xxx | ii | jj | kk 
-----+----+----+----
     |  1 |  4 | -1
     |  1 |  4 |  2
     |  1 |  4 | -3
     |  1 |  4 |  4
     |  1 |  4 | -5
     |  1 |  4 | -5
     |  1 |  4 |   
     |  1 |  4 |   
     |  1 |  4 |  0
     |  2 |  3 | -1
     |  2 |  3 |  2
     |  2 |  3 | -3
     |  2 |  3 |  4
     |  2 |  3 | -5
     |  2 |  3 | -5
     |  2 |  3 |   
     |  2 |  3 |   
     |  2 |  3 |  0
     |  3 |  2 | -1
     |  3 |  2 |  2
     |  3 |  2 | -3
     |  3 |  2 |  4
     |  3 |  2 | -5
     |  3 |  2 | -5
     |  3 |  2 |   
     |  3 |  2 |   
     |  3 |  2 |  0
     |  4 |  1 | -1
     |  4 |  1 |  2
     |  4 |  1 | -3
     |  4 |  1 |  4
     |  4 |  1 | -5
     |  4 |  1 | -5
     |  4 |  1 |   
     |  4 |  1 |   
     |  4 |  1 |  0
     |  5 |  0 | -1
     |  5 |  0 |  2
     |  5 |  0 | -3
     |  5 |  0 |  4
     |  5 |  0 | -5
     |  5 |  0 | -5
     |  5 |  0 |   
     |  5 |  0 |   
     |  5 |  0 |  0
     |  6 |  6 | -1
     |  6 |  6 |  2
     |  6 |  6 | -3
     |  6 |  6 |  4
     |  6 |  6 | -5
     |  6 |  6 | -5
     |  6 |  6 |   
     |  6 |  6 |   
     |  6 |  6 |  0
     |  7 |  7 | -1
     |  7 |  7 |  2
     |  7 |  7 | -3
     |  7 |  7 |  4
     |  7 |  7 | -5
     |  7 |  7 | -5
     |  7 |  7 |   
     |  7 |  7 |   
     |  7 |  7 |  0
     |  8 |  8 | -1
     |  8 |  8 |  2
     |  8 |  8 | -3
     |  8 |  8 |  4
     |  8 |  8 | -5
     |  8 |  8 | -5
     |  8 |  8 |   
     |  8 |  8 |   
     |  8 |  8 |  0
     |  0 |    | -1
     |  0 |    |  2
     |  0 |    | -3
     |  0 |    |  4
     |  0 |    | -5
     |  0 |    | -5
     |  0 |    |   
     |  0 |    |   
     |  0 |    |  0
     |    |    | -1
     |    |    |  2
     |    |    | -3
     |    |    |  4
     |    |    | -5
     |    |    | -5
     |    |    |   
     |    |    |   
     |    |    |  0
     |    |  0 | -1
     |    |  0 |  2
     |    |  0 | -3
     |    |  0 |  4
     |    |  0 | -5
     |    |  0 | -5
     |    |  0 |   
     |    |  0 |   
     |    |  0 |  0
(99 rows)

SELECT '' AS "xxx", *
  FROM J1_TBL CROSS JOIN J2_TBL a CROSS JOIN J2_TBL b;
 xxx | i | j |   t   | i | k  | i | k  
-----+---+---+-------+---+----+---+----
     | 1 | 4 | one   | 1 | -1 | 1 | -1
     | 2 | 3 | two   | 1 | -1 | 1 | -1
     | 3 | 2 | three | 1 | -1 | 1 | -1
     | 4 | 1 | four  | 1 | -1 | 1 | -1
     | 5 | 0 | five  | 1 | -1 | 1 | -1
     | 6 | 6 | six   | 1 | -1 | 1 | -1
     | 7 | 7 | seven | 1 | -1 | 1 | -1
     | 8 | 8 | eight | 1 | -1 | 1 | -1
     | 0 |   | zero  | 1 | -1 | 1 | -1
     |   |   | null  | 1 | -1 | 1 | -1
     |   | 0 | zero  | 1 | -1 | 1 | -1
     | 1 | 4 | one   | 1 | -1 | 2 |  2
     | 2 | 3 | two   | 1 | -1 | 2 |  2
     | 3 | 2 | three | 1 | -1 | 2 |  2
     | 4 | 1 | four  | 1 | -1 | 2 |  2
     | 5 | 0 | five  | 1 | -1 | 2 |  2
     | 6 | 6 | six   | 1 | -1 | 2 |  2
     | 7 | 7 | seven | 1 | -1 | 2 |  2
     | 8 | 8 | eight | 1 | -1 | 2 |  2
     | 0 |   | zero  | 1 | -1 | 2 |  2
     |   |   | null  | 1 | -1 | 2 |  2
     |   | 0 | zero  | 1 | -1 | 2 |  2
     | 1 | 4 | one   | 1 | -1 | 3 | -3
     | 2 | 3 | two   | 1 | -1 | 3 | -3
     | 3 | 2 | three | 1 | -1 | 3 | -3
     | 4 | 1 | four  | 1 | -1 | 3 | -3
     | 5 | 0 | five  | 1 | -1 | 3 | -3
     | 6 | 6 | six   | 1 | -1 | 3 | -3
     | 7 | 7 | seven | 1 | -1 | 3 | -3
     | 8 | 8 | eight | 1 | -1 | 3 | -3
     | 0 |   | zero  | 1 | -1 | 3 | -3
     |   |   | null  | 1 | -1 | 3 | -3
     |   | 0 | zero  | 1 | -1 | 3 | -3
     | 1 | 4 | one   | 1 | -1 | 2 |  4
     | 2 | 3 | two   | 1 | -1 | 2 |  4
     | 3 | 2 | three | 1 | -1 | 2 |  4
     | 4 | 1 | four  | 1 | -1 | 2 |  4
     | 5 | 0 | five  | 1 | -1 | 2 |  4
     | 6 | 6 | six   | 1 | -1 | 2 |  4
     | 7 | 7 | seven | 1 | -1 | 2 |  4
     | 8 | 8 | eight | 1 | -1 | 2 |  4
     | 0 |   | zero  | 1 | -1 | 2 |  4
     |   |   | null  | 1 | -1 | 2 |  4
     |   | 0 | zero  | 1 | -1 | 2 |  4
     | 1 | 4 | one   | 1 | -1 | 5 | -5
     | 2 | 3 | two   | 1 | -1 | 5 | -5
     | 3 | 2 | three | 1 | -1 | 5 | -5
     | 4 | 1 | four  | 1 | -1 | 5 | -5
     | 5 | 0 | five  | 1 | -1 | 5 | -5
     | 6 | 6 | six   | 1 | -1 | 5 | -5
     | 7 | 7 | seven | 1 | -1 | 5 | -5
     | 8 | 8 | eight | 1 | -1 | 5 | -5
     | 0 |   | zero  | 1 | -1 | 5 | -5
     |   |   | null  | 1 | -1 | 5 | -5
     |   | 0 | zero  | 1 | -1 | 5 | -5
     | 1 | 4 | one   | 1 | -1 | 5 | -5
     | 2 | 3 | two   | 1 | -1 | 5 | -5
     | 3 | 2 | three | 1 | -1 | 5 | -5
     | 4 | 1 | four  | 1 | -1 | 5 | -5
     | 5 | 0 | five  | 1 | -1 | 5 | -5
     | 6 | 6 | six   | 1 | -1 | 5 | -5
     | 7 | 7 | seven | 1 | -1 | 5 | -5
     | 8 | 8 | eight | 1 | -1 | 5 | -5
     | 0 |   | zero  | 1 | -1 | 5 | -5
     |   |   | null  | 1 | -1 | 5 | -5
     |   | 0 | zero  | 1 | -1 | 5 | -5
     | 1 | 4 | one   | 1 | -1 | 0 |   
     | 2 | 3 | two   | 1 | -1 | 0 |   
     | 3 | 2 | three | 1 | -1 | 0 |   
     | 4 | 1 | four  | 1 | -1 | 0 |   
     | 5 | 0 | five  | 1 | -1 | 0 |   
     | 6 | 6 | six   | 1 | -1 | 0 |   
     | 7 | 7 | seven | 1 | -1 | 0 |   
     | 8 | 8 | eight | 1 | -1 | 0 |   
     | 0 |   | zero  | 1 | -1 | 0 |   
     |   |   | null  | 1 | -1 | 0 |   
     |   | 0 | zero  | 1 | -1 | 0 |   
     | 1 | 4 | one   | 1 | -1 |   |   
     | 2 | 3 | two   | 1 | -1 |   |   
     | 3 | 2 | three | 1 | -1 |   |   
     | 4 | 1 | four  | 1 | -1 |   |   
     | 5 | 0 | five  | 1 | -1 |   |   
     | 6 | 6 | six   | 1 | -1 |   |   
     | 7 | 7 | seven | 1 | -1 |   |   
     | 8 | 8 | eight | 1 | -1 |   |   
     | 0 |   | zero  | 1 | -1 |   |   
     |   |   | null  | 1 | -1 |   |   
     |   | 0 | zero  | 1 | -1 |   |   
     | 1 | 4 | one   | 1 | -1 |   |  0
     | 2 | 3 | two   | 1 | -1 |   |  0
     | 3 | 2 | three | 1 | -1 |   |  0
     | 4 | 1 | four  | 1 | -1 |   |  0
     | 5 | 0 | five  | 1 | -1 |   |  0
     | 6 | 6 | six   | 1 | -1 |   |  0
     | 7 | 7 | seven | 1 | -1 |   |  0
     | 8 | 8 | eight | 1 | -1 |   |  0
     | 0 |   | zero  | 1 | -1 |   |  0
     |   |   | null  | 1 | -1 |   |  0
     |   | 0 | zero  | 1 | -1 |   |  0
     | 1 | 4 | one   | 2 |  2 | 1 | -1
     | 2 | 3 | two   | 2 |  2 | 1 | -1
     | 3 | 2 | three | 2 |  2 | 1 | -1
     | 4 | 1 | four  | 2 |  2 | 1 | -1
     | 5 | 0 | five  | 2 |  2 | 1 | -1
     | 6 | 6 | six   | 2 |  2 | 1 | -1
     | 7 | 7 | seven | 2 |  2 | 1 | -1
     | 8 | 8 | eight | 2 |  2 | 1 | -1
     | 0 |   | zero  | 2 |  2 | 1 | -1
     |   |   | null  | 2 |  2 | 1 | -1
     |   | 0 | zero  | 2 |  2 | 1 | -1
     | 1 | 4 | one   | 2 |  2 | 2 |  2
     | 2 | 3 | two   | 2 |  2 | 2 |  2
     | 3 | 2 | three | 2 |  2 | 2 |  2
     | 4 | 1 | four  | 2 |  2 | 2 |  2
     | 5 | 0 | five  | 2 |  2 | 2 |  2
     | 6 | 6 | six   | 2 |  2 | 2 |  2
     | 7 | 7 | seven | 2 |  2 | 2 |  2
     | 8 | 8 | eight | 2 |  2 | 2 |  2
     | 0 |   | zero  | 2 |  2 | 2 |  2
     |   |   | null  | 2 |  2 | 2 |  2
     |   | 0 | zero  | 2 |  2 | 2 |  2
     | 1 | 4 | one   | 2 |  2 | 3 | -3
     | 2 | 3 | two   | 2 |  2 | 3 | -3
     | 3 | 2 | three | 2 |  2 | 3 | -3
     | 4 | 1 | four  | 2 |  2 | 3 | -3
     | 5 | 0 | five  | 2 |  2 | 3 | -3
     | 6 | 6 | six   | 2 |  2 | 3 | -3
     | 7 | 7 | seven | 2 |  2 | 3 | -3
     | 8 | 8 | eight | 2 |  2 | 3 | -3
     | 0 |   | zero  | 2 |  2 | 3 | -3
     |   |   | null  | 2 |  2 | 3 | -3
     |   | 0 | zero  | 2 |  2 | 3 | -3
     | 1 | 4 | one   | 2 |  2 | 2 |  4
     | 2 | 3 | two   | 2 |  2 | 2 |  4
     | 3 | 2 | three | 2 |  2 | 2 |  4
     | 4 | 1 | four  | 2 |  2 | 2 |  4
     | 5 | 0 | five  | 2 |  2 | 2 |  4
     | 6 | 6 | six   | 2 |  2 | 2 |  4
     | 7 | 7 | seven | 2 |  2 | 2 |  4
     | 8 | 8 | eight | 2 |  2 | 2 |  4
     | 0 |   | zero  | 2 |  2 | 2 |  4
     |   |   | null  | 2 |  2 | 2 |  4
     |   | 0 | zero  | 2 |  2 | 2 |  4
     | 1 | 4 | one   | 2 |  2 | 5 | -5
     | 2 | 3 | two   | 2 |  2 | 5 | -5
     | 3 | 2 | three | 2 |  2 | 5 | -5
     | 4 | 1 | four  | 2 |  2 | 5 | -5
     | 5 | 0 | five  | 2 |  2 | 5 | -5
     | 6 | 6 | six   | 2 |  2 | 5 | -5
     | 7 | 7 | seven | 2 |  2 | 5 | -5
     | 8 | 8 | eight | 2 |  2 | 5 | -5
     | 0 |   | zero  | 2 |  2 | 5 | -5
     |   |   | null  | 2 |  2 | 5 | -5
     |   | 0 | zero  | 2 |  2 | 5 | -5
     | 1 | 4 | one   | 2 |  2 | 5 | -5
     | 2 | 3 | two   | 2 |  2 | 5 | -5
     | 3 | 2 | three | 2 |  2 | 5 | -5
     | 4 | 1 | four  | 2 |  2 | 5 | -5
     | 5 | 0 | five  | 2 |  2 | 5 | -5
     | 6 | 6 | six   | 2 |  2 | 5 | -5
     | 7 | 7 | seven | 2 |  2 | 5 | -5
     | 8 | 8 | eight | 2 |  2 | 5 | -5
     | 0 |   | zero  | 2 |  2 | 5 | -5
     |   |   | null  | 2 |  2 | 5 | -5
     |   | 0 | zero  | 2 |  2 | 5 | -5
     | 1 | 4 | one   | 2 |  2 | 0 |   
     | 2 | 3 | two   | 2 |  2 | 0 |   
     | 3 | 2 | three | 2 |  2 | 0 |   
     | 4 | 1 | four  | 2 |  2 | 0 |   
     | 5 | 0 | five  | 2 |  2 | 0 |   
     | 6 | 6 | six   | 2 |  2 | 0 |   
     | 7 | 7 | seven | 2 |  2 | 0 |   
     | 8 | 8 | eight | 2 |  2 | 0 |   
     | 0 |   | zero  | 2 |  2 | 0 |   
     |   |   | null  | 2 |  2 | 0 |   
     |   | 0 | zero  | 2 |  2 | 0 |   
     | 1 | 4 | one   | 2 |  2 |   |   
     | 2 | 3 | two   | 2 |  2 |   |   
     | 3 | 2 | three | 2 |  2 |   |   
     | 4 | 1 | four  | 2 |  2 |   |   
     | 5 | 0 | five  | 2 |  2 |   |   
     | 6 | 6 | six   | 2 |  2 |   |   
     | 7 | 7 | seven | 2 |  2 |   |   
     | 8 | 8 | eight | 2 |  2 |   |   
     | 0 |   | zero  | 2 |  2 |   |   
     |   |   | null  | 2 |  2 |   |   
     |   | 0 | zero  | 2 |  2 |   |   
     | 1 | 4 | one   | 2 |  2 |   |  0
     | 2 | 3 | two   | 2 |  2 |   |  0
     | 3 | 2 | three | 2 |  2 |   |  0
     | 4 | 1 | four  | 2 |  2 |   |  0
     | 5 | 0 | five  | 2 |  2 |   |  0
     | 6 | 6 | six   | 2 |  2 |   |  0
     | 7 | 7 | seven | 2 |  2 |   |  0
     | 8 | 8 | eight | 2 |  2 |   |  0
     | 0 |   | zero  | 2 |  2 |   |  0
     |   |   | null  | 2 |  2 |   |  0
     |   | 0 | zero  | 2 |  2 |   |  0
     | 1 | 4 | one   | 3 | -3 | 1 | -1