can you please describe (and explain) your expected results for this sample data
edit...what version of SQL are you using?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day