[thomas_w]

Was soll's, mach ich mir eben selber ein kleines Beispiel.

CREATE TABLE test1 (
 id INT NOT NULL,
 datum1 VARCHAR(8) NOT NULL,
 datum2 VARCHAR(8) NOT NULL,
 PRIMARY KEY(id)
);

INSERT INTO test1 VALUES 
( 1, '20100501', '20100502' ),
( 2, '20100503', '20100504' ),
( 3, '20100505', '20100506' );


SELECT t1.datum1, t1.datum2, t2.datum1
  FROM ( SELECT id+1 AS id, datum1, datum2
           FROM test1 ) t1
  LEFT JOIN ( SELECT id , datum1, datum2
           FROM test1 ) t2
    ON t2.id = t1.id
ORDER BY t1.datum1;
     
+----------+----------+----------+
| datum1   | datum2   | datum1   |
+----------+----------+----------+
| 20100501 | 20100502 | 20100503 |
| 20100503 | 20100504 | 20100505 |
| 20100505 | 20100506 | NULL     |
+----------+----------+----------+
3 rows in set (0.01 sec)

mysql>

Grüße
Thomas