I cannot use the query you proposed as the tables A and B never have the same values for the field "Value" that is
Table A (the table is unordered by Date) ----------- Date | Value 2006-09-01 | 100 2006-10-01 | 200 2006-07-01 | 50 Table B (the table is unordered by Date) ----------- Date | Value 2006-09-13 | 200 2006-07-25 | 500 RESULT (the result table is ordered by the field "A.Date" and by the field "B.Date") -------------- PROGR | A.Date | A.VALUE | B.Date | B.Value 1 | 2006-07-01 | 50 | 2006-07-25 | 500 2 | 2006-09-01 | 100 | 2006-09-13 | 200 3 | 2006-10-01 | 200 | ? | ? ----- Original Message ----- From: "Schroeder, Alexander" <[EMAIL PROTECTED]> To: "Luca Calderano" <[EMAIL PROTECTED]>; <[email protected]> Sent: Thursday, September 14, 2006 11:39 AM Subject: RE: sql help needed > Hello Luca, > > do you mean something like: > > select rowno, a."DATE" AS a_date, a."VALUE", b."DATE" as b_date, b."VALUE" > from a, b where a."VALUE" = b."VALUE" (+) ORDER BY a_date, b_date > > Regards > Alexander Schröder > SAP Labs Berlin > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
