Help with complex SQL
From: Naeem <naeem.saleem_at_mandg.co.uk>
Date: 4 Sep 2002 04:21:58 -0700
Message-ID: <f223e72a.0209040321.67707d05_at_posting.google.com>
Date: 4 Sep 2002 04:21:58 -0700
Message-ID: <f223e72a.0209040321.67707d05_at_posting.google.com>
Hi all,
Have the following two column in a table:-
Maturity_date Schedule
If any of the dates in the Schedule column are greater then the
Maturity_date then I want to ignore them ... i.e. 01-JAN-2003 30 in
the above example.......
What is the easiest way of achieving this in SQL?
01-DEC-2002 {01-JAN-2002 10,01-FEB-2002 20,01-JAN-2003 30}
A date List of Dates and amounts with comma seperator.
Many thanks in advance. Received on Wed Sep 04 2002 - 13:21:58 CEST