I have two joined tables that return the results
Primary key, foreign key, date and repeating date the results are grouped by the foreign key.
Id id, date1 date2
1 1 1/1/10 6/1/15
2 1 1/1/10 6/1/15
3 1 1/1/10 6/1/15
4 2 1/1/10 2/1/14
5 2 5/1/10 2/1/15
6 3 5/1/10 4/1/15
7 3 6/7/10 4/1/15
I would like the results to return
Id id, date1 date2
1 1 1/1/10
2 1 1/1/10
3 1 1/1/10 6/1/15
4 2 1/1/10
5 2 5/1/10 2/1/15
6 3 5/1/10
7 3 6/7/10 4/1/15
I would like the results to return results but the last column replace repeating dates with a null except for the last date in each group.